Hi All

I have a spreadsheet that contains a cell that calculates the number of days an item has been on hold. The cell has a couple of Conditional Formats and a formula in it. The conditional formatting is dependent on 2 other cells that have a start and end date. Below is the formula and the conditional formatting?

If Cells D6 and E6 are blank then F6 is also Blank and for formula used is : =IF(ISBLANK(E6),"",NETWORKDAYS(D6,E6))

If there is are dates in D3 and E3 Then F6 turns Green and enters the number of days between the dates – Conditional Formatting? Using a formula - =AND(ISNUMBER(K6),ISNUMBER(L6))

If there is a date in D3 and E3 is blank the F6 stays blank but still turns Red – Conditional Formatting? Using a formula - =AND(ISNUMBER(K6),ISBLANK(L6)) I would like to amend this formula/Conditional format so that the cell still turns Red but also enters a text string such as “No End Date Entered”.

Thanks in advance for any help
Sandy