Conditional Format

Closed
minimolly Posts 1 Registration date Friday May 2, 2014 Status Member Last seen May 2, 2014 - May 2, 2014 at 10:32 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 6, 2014 at 10:56 AM
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
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
May 6, 2014 at 10:56 AM
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.
0