Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with conditional-formatting
Search options not deleted
user 117311
For questions about conditional formatting in spreadsheets.
0
votes
Accepted
Conditional Formatting with Multiple Conditions Weekday and Time
Please try this one instead:
=AND((weekday(C$4:C24)=3),(EQ(RIGHT(C$4:C24,8),"21:00:00")))
Do take notice of both the $ signs. The formula will not work if you omit them.
PS: When asking try giving t …
- 13.1k
0
votes
Accepted
How to highlight cell if any of 6 cells to the right not blank
...highlight the value in Column D if any of the cells in the same rows from Column E:K are not blank
Please try the following formula for the range D137:D152
=NOT(COUNTIF(E137:K137,"<>")=0)
- 13.1k
-1
votes
Conditional formatting custom formula not working in google sheets
In your formula you have to omit the >1.
Your Conditional Formatting formula should be:
=COUNTIF($B1:$B100,"month")
(The answer provided is in relation to your info. There is vital info missing fr …
- 13.1k
3
votes
Accepted
Apply conditional formatting to a blank cell if another cell in the row is not blank
The formula you need is the following:
=NOT(ISBLANK($H3))*(ISBLANK(I3))
Please pay attention to the $ sign in front of H3.
Using the $ (dollar) sign we "lock" the column and the formatting is bein …
- 13.1k
3
votes
1
answer
262
views
How can we retain authorship when we copy/paste a comment?
We have comments in a Google Spreadsheet that were not originally written by us.
The cells the comments are written in already have "Conditional format rules" applied to them (e.g., cell H2).
We w …
- 13.1k
0
votes
Conditional Formatting in Google Sheets based on the same rows conditional format
You do not need to use AND.
You just need to create 2 rules for your range (or maybe more?) using the following formulas:
for the checkbox: =COUNTIF($D16, "=TRUE")
for the "HIGH": =$A16="HIGH"
…
- 13.1k
1
vote
Conditional Formating for Google Sheet comparing to list of text (highlight duplicates)
EDIT (following your comment)
All duplicate values highlighted in both columns is achieved using:
In range D3:D27: =COUNTIF($A$3:$A,D3)
In range A3:A27: =COUNTIF($D$3:$D,A3)
First appr …
- 13.1k
0
votes
Conditionally formatting a column based on content of nearby column
Please try the following formula for your range:
=B1:B<>""
- 13.1k
1
vote
Comparing cell value 450-500 to another cell of value 475 in Google Sheets
You should use the following formula having an IF statement:
=(IFERROR(MAX(SPLIT(D3,"-")),0))>F3
- 13.1k
1
vote
Google Sheets - Conditional Formatting question
You would need 2 rules to achieve your results.
The 1st one -as you already mentioned- is Text contains 0
The 2nd is very similar to your 1st one Text contains 00
Filters must be in the correct order
…
- 13.1k
0
votes
highlight if value is duplicate and corresponding cell of all other duplicates is blank
(Please adjust columns and row numbers accordingly)
The formula you need for column L (or even better columns L to M) is:
=and(COUNTIFS($L$11:$L11, $L11)>1, not($M11=""))
Please note that the w …
- 13.1k
1
vote
Accepted
Conditional formatting for cells that have date/time within the last 24 hours
...say the current time is 930am, so the cells that have a time BEFORE 9:30am yesterday should turn red. The cells that have a time AFTER 9:30am yesterday should remain unaffected.
There is a set …
- 13.1k
0
votes
Accepted
Conditional formatting on merged cells
As you already know, merged cells only have values in the top left cell.
That is why you will need a helper column eg. in column P having all cells un-merged.
You can then use a formula like: =$P3= …
- 13.1k
1
vote
Is it possible to highlight the minimum value in a table on Gsheets?
You should 2 rules
=I12=MIN($I$12:$L$16)
and
=I12=MIN($I$12:$L$16)
Adjust your ranges accordingly paying attention to the dollar sign $
- 13.1k
1
vote
Accepted
How do I conditional format a table in Google Sheets based on two other cell values?
You can use the following formula under conditional formatting:
=AND(C5<$B$2,C5>$A$2)
(Adjust ranges to your needs)
- 13.1k