| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help with a conditional format in regards to "date" input
I have a scenario where a date is inputed in cell B2. I want cell B3 to go
red if a date is not entered. Once a date is entered, I need the cell to go back to clear. Help!!! I'm out of time and am not that familiar with Excel! Thanks! John |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need help with a conditional format in regards to "date" input
Select cell B3
Goto the menu FormatConditional Formatting Select Formula Is Enter this formula in the little box on the right: =NOT(ISNUMBER(B2)) Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Fritter" wrote in message ... I have a scenario where a date is inputed in cell B2. I want cell B3 to go red if a date is not entered. Once a date is entered, I need the cell to go back to clear. Help!!! I'm out of time and am not that familiar with Excel! Thanks! John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
| "Daisy-Chain" a conditional format? | Excel Discussion (Misc queries) | |||
| Conditional Format Formula "includes" | Excel Discussion (Misc queries) | |||
| inserting a conditional "go to" command on a excel "if" function | Excel Worksheet Functions | |||
| How do make input date by "month/day" in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
