Conditional Formatting on Color

[Guest]

Is there a way to conditionally format a cell to a color only if a referenced
cell is already conditionally formatted to a color. Ex; format cell A2 to red
if cell A1 is conditionally formatted to yellow?

 

[Guest]

You can check for the same logic applied to the other conditionally formatted
cell. Using your example, if A1 is conditionally formatted to yellow when
the cell value is > 1, then, you can conditionally format A2 to red with the
formula "=A1>1"

 

[Guest]

I think that is in the right directions. Can I format the cell for multiple
conditions. Ex: Format A1 to yellow if B1 is >1, then format A2 to red if B2
is >1 and B1 >1?

 

[Guest]

Yes, by using a formula like this for the A2 conditional format:

=AND(B1>1, B2>1)

 

[Guest]

Thank you for the help, I knew there was an easier way than trying to look at
the color properties of the cell.