|
|
#1
12-15-2015, 09:10 AM
|
|||
|
|||
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! 
|
| Tags |
| blanks, condtional formatitng, due date |
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 10 
Office 2010 32bit
Threaded Mode