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
How to copy/paste conditional formatting in Google Sheets (without including the original ce...
First use the copy command Edit-->Copy
You can then use a special paste for this as shown in the image.
Edit-->Paste special-->Conditional formatting only
- 13.1k
0
votes
Conditional formatting dependent on date and content in other cell
You do not quite specify the "neighboring" cells.
You also ask: "to adapt the formula, to paste it over the complete row"
So here are 3 options.
You choose the one best suited to your needs.
Apply on …
- 13.1k
0
votes
Accepted
How can I apply a conditional format in Google Spreadsheets based on multiple factors?
You will need several rules in your quest.
Right from the start you will need to reset the Fill colour for all of your cells.
Remember that ALL these rules are applied on the same range, which is D4:A …
- 13.1k
1
vote
Accepted
Using a custom formula on a sheet that is constantly expanding
You can NOT use open ranges in Conditional Formatting.
Still.
Select a range till last row as a range and the range will auto expand to new rows as the sheet expands.
(In your case A2:A641 will become …
- 13.1k
3
votes
Accepted
How to Apply Conditional Formatting Based on Adjacent Cell Value for Entire Column?
Please use the following formula
=B2>=A2 for green (if the cell on the right is greater than or equal to the cell on the left)
=AND(B2>=A2,B2<>"")
=B2<A2 for red (if the cell on the right is less tha …
- 13.1k
1
vote
Accepted
How to automatically fill, sort and conditionally format 1st day of the week according to gi...
Please use the following formula
=SEQUENCE(COUNT(B5:B),1,DATE(A2,MONTH(A1&1),1),1)
You then format your cells as Tue found under Format >Number >More date and time formats
I also noticed that you ha …
- 13.1k
1
vote
Accepted
How to combine these formulas in one conditional formatting rule
To one cell A1 only.. it will be highlighted whenever the the formula is true..
What you need is a COUNTIFS formula as your conditional rule for cell A1
=COUNTIFS($Q9:$Q,"=Consultation",S$9:S,"=")>0 …
- 13.1k
1
vote
How can I highlight a column of cells (H) if the date in the cell is more than a week old, a...
You mentioned:
Highlight order date if it is more than a week old,
and there is nothing in the cell for the receive date
Please use the following rule:
=AND(G2<>"",G2<TODAY()-7,ISBLANK(H2))
- 13.1k
3
votes
Find or conditional format a column of phone numbers NOT in desired format
You mentioned
How can I use a filter or conditional formatting to find all numbers that are NOT in this format (#### ### ###).
Please use the following conditional-formatting rule
=IF(A1<>"",(IF(ISN …
- 13.1k
2
votes
Accepted
Conditional Format if cell contains partial match for text
Please try the following formula in Custom formula is
=IFERROR(IF(MATCH("*"&INDIRECT("H5")&"*",B2,0)>0,true,),false)
- 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
1
vote
Accepted
Color a cell if the text inside it is not the first time it has appeared on the sheet
Please use the following rule
=countif($A$2:$A2,A2)>1
(adjust range to your needs)
- 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
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
How to check and replace cells
You could use the following formula in cell D3 (or anywhere else you may need to).
=IF(AND(REGEXMATCH(B3, ","),C3="none"), "USA","Oops")
(Of course you can change "Oops" to whatever you like or ev …
- 13.1k