Conditional format refers to two cells

  • Thread starter Thread starter DOUG
  • Start date Start date
D

DOUG

How would I tell excel to format a cell based on values in the cell PLUS a
date formula in anouther cell? For example, "if the date in cell P2 is
greater than 365 days AND the cell value in cell Q2 is greater than 9 THEN
color the cell red".

DOUG ECKERT
 
From first dropdown, select 'formula is'. Then input the following:

=AND(P2>365,Q2>9)

Under format - pattern, select red.
Done.
 
Back
Top