View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default 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.