Conditional Formatting

E

Excel Learner

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.
 
D

Duke Carey

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
 
Top