Hi everyone,

I am trying to use the if function while conditional formatting and here is my issue:

I want cells in column A to appear green when cell E1 contains "Back from BT" as well a date -- ex. Back from BT 29-MAR-2010

I have the formatting set as =IF(A1="Back from BT",TRUE,FALSE).....I know this is wrong as I need to include a "Variable" for the date.

It should say =IF(A1="Back from BT VARIABLE FOR DATE",TRUE,FALSE).

This is because the Date will change.

Anty suggestions? Thanks