Conditional Format [Closed]

Report
Posts
1
Registration date
Friday May 2, 2014
Status
Member
Last seen
May 2, 2014
-
Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
-
Hello,





Hello,
I am trying to set a conditional format using different columns and I can't seem to get it right

Vacancy Date R.P Done
1/25/2014 1/30/2014
2/20/2014
3/15/2014 3/25/2014
4/24/2014
4/28/2014

I want to format to be in column "B" (R.P. Done) based on the "A" (Vacancy Date) if column "A" has a date, and column B does not and if Column B is more than 3 days make cell "B" yellow. If it is more than 5 days make cell "B" Red. If you could help that would be wonderful. Thanks
Reply

1 reply

Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
448
Hi Minimolly,

"if column "A" has a date, and column B does not"
Formula 1: =AND($A1<>"",$B1="")

"If it is more than 5 days make cell "B" Red. "
Formula 2: =$B1-$A1>5

"if Column B is more than 3 days make cell "B" yellow"
Formula 3: =$B1-$A1>3

Best regards,
Trowa

Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!