Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format based on other cells | Excel Discussion (Misc queries) | |||
Conditional format for cells. | New Users to Excel | |||
Where is the Data Tools group Help refers to when splitting cells | Excel Worksheet Functions | |||
how do i copy format which refers to every OTHER cell | Excel Worksheet Functions | |||
How do I keep the format of a cell that an if statment refers to? | Excel Discussion (Misc queries) |