Conditional Formatting Based on Cell Color Help

[gvsu141]

Is there a way to format cells based on the cell color of another cell? I can't format based on value for what I am trying to do.

Simplified Example: If one cell in the range b2-b6 is yellow, format cell b7 yellow (color #65535)

I can use Excel 2010 or 2007

[pike]

Hi gvsu141
if the cells in the range are not conditional formating then use

Please Login or Register  to view this content.

then add conditional formating to B7 so if the value= 1 format to 65535