Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hi All I'm trying to solve an issue with conditional formatting. Essentially , if any of the cells in the selected area contain 0.00 , colour every selected cell red. eg: 1 16.00 2.00 3.5 1.20 2 18.00 2.00 2.5 1.28 3 20.00 2.00 1.5 1.33 4 22.00 0.00 0.0 1.33 5 22.00 0.00 0.0 1.33 6 22.00 0.00 0.0 1.33 7 22.00 0.00 0.0 1.33 In this example all the cells in rows 4 to 7 would be red. Can someone advise? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting Assistance | Excel Worksheet Functions | |||
Looking for assistance for an unusual conditional formatting probl | Excel Discussion (Misc queries) | |||
Formatting Assistance | Excel Discussion (Misc queries) | |||
Conditional Formatting - further assistance required | Excel Worksheet Functions | |||
Conditional Formatting Assistance | Excel Discussion (Misc queries) |