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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 6, 2014 at 10:56 AM
Related:
- Conditional Format
- Format factory - Download - Other
- Excel date format dd.mm.yyyy - Guide
- Samsung format code - Guide
- Kingston format utility - Download - Storage
- Marksheet format in excel - Guide
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
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.
"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.