How to enable conditional formatting based on if-else condition on 2 previous date cells ?

**dragonballdbz** · 10-18-2019, 01:33 AM

Cell A1, C1 always contains a date. Cell B1 contains either a date or NA or maybe empty. If B1 contains date, then I want C1 to become red on 2nd work day onwards after B1. If B1 is empty or contains NA, then I want C1 to become red on 4th work day onwards after A1.

For example: if A1 = 18/Oct and B1 = 25/Oct, then C1 should become red 29/Oct onwards. if A1 = 18/Oct and B1 = NA, then C1 should become red 24/Oct onwards.

What codes should I put in conditional formatting? Multiple codes are OK.

Excel Conditional Formatting.jpg

**Keebellah** · 10-18-2019, 02:32 AM

Use TODAY() as the variable date v.s. the date in the cell when configuring the conditional format, probably two conditions required

How to enable conditional formatting based on if-else condition on 2 previous date cells ?

LinkBack

Thread Tools

Rate This Thread

Display

How to enable conditional formatting based on if-else condition on 2 previous date cells ?

Re: How to enable conditional formatting based on if-else condition on 2 previous date cel

Thread Information

Users Browsing this Thread

Similar Threads

Conditional Formatting based on previous worksheet

Using conditional formatting to highlight cells based on date + 1 other condition

Conditional formatting large range of cells, based on percentage of previous cell in range

conditional formatting of cells with quarters based on date ranges in other cells

Conditional Formatting based on text in previous cells

[SOLVED] Excel 2007 : How to apply conditional formatting to cells based on their previous cell value.

Conditional formatting based on decision to enable/disable macros?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions