Condition Formatting Using Formular - Wont carry over to range :?

[SJ_Misty]

Hi - So I am currently tracking a projects actual dates against a set of baseline dates in excel, I want to condition format cells when an activity is late against the baseline - I and using this formulas below

=IF(AND(OR(A3>TODAY(),A3=TODAY()),B3=""),TRUE,FALSE) no fill - cell to remain white, activity in the future

=IF(AND(A3<today(),B3=""),TRUE,FALSE) - Cell to turn red LATE

Cell Value = >0 Turn green activity complete.

column A is baseline dates and B is actual dates - all of the condition formatting is in column B.

this issue I have is when I copy and paste the conditional format to the range of cells below (down column b) to formula still looks to A3 and B3? I have not locked any cells so I don't know why it is doing this?

I can copy and pate it one cell at a time and it works fine, but as soon as I select a range it doesn't seem to work??

if anyone can help - you will save me many hours of copy pate cop paste!

 

[SJ_Misty]

Sorry - the second formula should read =IF(AND(A3<today(),B3=""),TRUE,FALSE) and should turn the cell red