Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
In Column A are Numbers. In Column C are Dates. I'd like to format cells in Column A and Column C based on these conditions: If the Number in Column A is greater than 90, and if the Date in Column C is older than 30 days old, fill both cells color red. I prefer to do this in VBA. Just to clarify, here's an example: If the cell value in A1 is 91, and the date in C1 is 1/1/2009, I'd like to have both cells A1 and C1 filled with the color red. Thanks in advance for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to sum cells based on conditions | Excel Worksheet Functions | |||
How do I format a cell based on conditions in five different cells | Excel Discussion (Misc queries) | |||
shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
Conditional Formatting 4+ conditions, format rows based on cell | Excel Programming | |||
Averaging Cells Based On Conditions in Neighboring Cells | Excel Discussion (Misc queries) |