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
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Code for formatting android phone - 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
