New answers tagged conditional-formatting
2
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 than the cell on the left)
=AND(B2<A2,B2<>"")
2
Either the Apply to range or the formulas are wrong.
Instead of B:B use B2:B
OR
Instead of B2>=A2 it should be B1>=A1
Instead of B2<A2 it should be B1>A1
Apply to range you might select the whole column B
Use a custom formula with relative references i.e. B1 instead or $B$1
First rule
Second rule
Related
How to conditional format in ...
1
Custom number formatting supports conditionals, but only two of them plus a default format. So, to display millions and billions of dollars, you can use Format > Number > More Formats > Custom number format with something like this:
[>999999999.999]$#.00,,, "B";[>999999.999]$#.00,, "M";$#,##0_M
Unfortunately, this will ...
Top 50 recent answers are included
Related Tags
conditional-formatting × 383google-sheets × 377
formulas × 113
google-apps-script × 15
google-sheets-dates × 15
google-sheets-arrayformula × 12
formatting × 8
google-sheets-query × 7
regex × 7
date × 6
regexextract × 5
data-validation × 4
google-sheets-cell-format × 4
importrange × 3
vlookup × 3
google-sheets-custom-function × 3
filter × 3
google-apps × 2
google-forms × 2
google × 2
if-this-then-that × 2
text-formatting × 2
google-sheets-data-validation × 2
highlight × 2
search × 1