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
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