Previous Topic Next Topic

Conditional formatting

Closed
greg - May 25, 2010 at 12:42 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 25, 2010 at 05:12 PM
Hello,

I need to have a row change colors based on multiple cells in a row. For instance if a date (1/1/10) ise, etc.entered in cell A1, then the row would turn red. Then/or if B1 had a date older than A1 (1/2/10), the row would turn green. Then/or if C1 had a date older than A1 or B1 (1/3/10) then the row would turn blus

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 25, 2010 at 05:12 PM
1 Select all cells
2. Goto conditional Format and add
=$a1<>"" and click on format and choose red color
=AND($b1<>"",$b1<$a1) and click on format and choose green color
=AND($c1<>"",$c1<$a1, $c1<$b1) and click on format and choose blue color
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses