#1
|
|||
|
|||
Conditional Formatting- Only format cells once data is entered
I have a excel spreadsheet with the due date in field "D" and the status in field "e". I have successfully used conditional formatting to highlights due dates that are past due and have a status that is open RED using : =AND(E2<>"Done",E2<TODAY()) HOWEVER.... this also turns the cells that i have not yet entered in the task/duedate/status in red too. How do i make this ONLY look at cells that have text/date? I tried to use conditional formatting>format only cells that contain>no blanks and this did not work. please help! |
#2
|
|||
|
|||
=AND(E2<>"", E2<>"Done", E2<TODAY())
|
Tags |
blanks, condtional formatitng, due date |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Prevent "non-template2 font and format to be entered on slide | Ochimus | PowerPoint | 0 | 06-27-2015 04:01 PM |
How can I count cells based on their fill color that was set by conditional format | trueimage | Excel Programming | 1 | 10-25-2013 12:08 PM |
Copy format created by a conditional formatting | spk | Excel | 2 | 04-10-2013 04:41 AM |
Conditional Formatting over copied and pasted data | kb3264 | Excel | 6 | 07-11-2012 07:12 AM |
VBA Code to auto resize cells when text entered | OTPM | Excel Programming | 0 | 09-18-2011 04:21 AM |