View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Excel learner Excel learner is offline
external usenet poster
 
Posts: 6
Default Conditional Formatting on Color

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?