Conditional format refers to two cells

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
 
L

Luke M

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

=AND(P2>365,Q2>9)

Under format - pattern, select red.
Done.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difference Between Dates WITH Conditional Formatting 2
Adding cells until they are greater than a lookup cell and returning a value 1
Conditional format 1
Word macro that can call cells out of Excel for a find and replace 0
Conditional Formatting to Another Cell 0
*Issue* Concatenate dates in a large range of cells in a row. 5
Subtracting two cell dates and highlight if over due by a certain amount of days 0
Conditional Format Based on Date 3

Top