|
| 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
June 17th, 2009, 07:09 PM
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
June 17th, 2009, 07:29 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
