Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi there,
I need to add a set of formats to a column but based on IF statements. For example, I have column A (Date Raised) and column I (Date Acknowledged), I want to be able to colour the cells based on what date was added to column I e.g: If I <= (A+2) then cell is green If I (A+2) then cell is red with white text If I is null then ignore Can someone help with some code please. Thanks in advance!!! Mav |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple Conditional Formatting-HELP | Excel Discussion (Misc queries) | |||
Conditional Formatting with multiple spreadsheets | Excel Discussion (Misc queries) | |||
Multiple Conditional Formatting | Excel Discussion (Misc queries) | |||
multiple conditional formatting | Excel Worksheet Functions | |||
Multiple Conditional Formatting Using VBA | Excel Programming |