thanks steven
thats kind of what im after but instead of looking for values in the cell i
want it to look for cell colour (red)


"Steven" wrote:


If you are looking to see if any of the cells have a value less than 0 (I am
making a guess here) then for example:

With values in Col A-G. Starting with row 10.

Then in H10 use Format / Conditional Formatting / You want to use Formula Is
/ and in the Formula put =MIN(A10:G10)<0 / and use the Format button to
format cell F10.

Then if this is it you can copy F10 down.

Hope this helps.

Steven