View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Colin Hayes Colin Hayes is offline
external usenet poster
 
Posts: 465
Default Conditional Formatting assistance


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?