Multiple Conditional Formatting in VB
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
|