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

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

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