Change cell colour

C

cityfc

what i would like is to put a conditional format in say a22 and have excel
look along 22 row and check each of 7 columns for a red cell and if it finds
one make a22 a red cell

please help
 
S

Steven

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
 
C

cityfc

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