Conditional Formatting
 

Is it possible to format a cell to change color based on the color of another
cell? Example: Change cell A2 to red if cell A1 is blue.

Conditional Formatting
 

If A1 is blue as the result of conditional formatting, apply the same
condition to A2 but change the color pattern. Otherwise, you'll need to
resort to customized VBA code

"Excel Learner" wrote:

Is it possible to format a cell to change color based on the color of another
cell? Example: Change cell A2 to red if cell A1 is blue.