Excel 2007 : Conditional Formatting using "IF" Function

[shamilt4]

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

[JBeaucaire]

1) You don't need to use an IF and put in TRUE/FALSE as the results. CF formulas are by nature TRUE/FALSE tests. IF you simply leave off the IF() part, you can still get accurate answers.

Try this, put this in an empty cell:

=A1=B1

If those two cells are equal, you'll get a TRUE answer, else FALSE. See?


2) Try this, assuming the date you want to include is in D1:

=A1="Back from BT " & TEXT(D1, "DD-MMM-YYYY")