View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vergel Adriano Vergel Adriano is offline
external usenet poster
 
Posts: 857
Default Conditional Formatting on Color

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 "=A11"

"Excel Learner" wrote:

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?