Also noticed that just selecting and inputting the code you gave into the conditional format worked as well and preserved the rest of my formatting. My mistakes was I was not putting TRUE, FALSE in my if statement I was putting formals in there trying to make it do it much.
Just in case anyone tries to do something like I am doing here is the full application of the code
A2 A2-M2 N2 O2 P2 Q2
Visit date : acct data : Min : Max : Reschedule : Overdue
A2:cell that needs updated
A2-O2: Only changed when needed
Then I Highlighted Rows A2 through R2
Formula is:: =IF($Q$2<TODAY(),TRUE,FALSE)
Set to red
Set to Yellow
Formula is :: =IF($P$2<TODAY(),TRUE,FALSE)
Then I repeated for the other 62 Accts I have to keep up with.
The benefit is now if I need to schedule a visit it turns yellow. If I go past the time I am contractually allowed to put them off it will turn red so I know to go there ASAP.