Conditional Formatting according to colour of other cell

[lhk201]

Is it possiable to conditional format an area of cells based on whether or not there is a red shading cell in that row, i.e. for cells A1:A15 if there is a red shaded cell in A16:A25 then the entire of A1:A15 row needs to be shaded red as well??

Many thanks

 

[devonknows]

You would need to Look into using VBA for this, there isnt a Formula from memory that returns a specific colour or colour index jus a 1 or 0 if it has colour.

Search the forums for Return Cell Colour or use a search engine, i just did and plenty show up

Regards,

 

[lhk201]

So there is no way to do this not using a macro?