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
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
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
Related:
- Conditional formatting
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Code for formatting android phone - Guide
- Excel conditional formatting based on date - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 25, 2010 at 05:12 PM
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
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