If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional format refers to two cells
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 |
#2
|
|||
|
|||
Conditional format refers to two cells
From first dropdown, select 'formula is'. Then input the following:
=AND(P2365,Q29) Under format - pattern, select red. Done. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "DOUG" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|