Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to set up cell formatting using a combined "If or" and "If and'
statement. My worksheet is as follows: B C D ect A1 Jan Feb Mar Acct Name Im trying to set the conditional format to show the account name (A2) in red if a date has not been filled in, in B2. In other words If B1=Jan, or C1=Feb, or D1=Mar and no date has been entered in cell B2 use red font in A2. Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CONDITIONAL FORMATTING OR AN 'IF' STATEMENT? | Excel Discussion (Misc queries) | |||
Can I use an if statement within the conditional formatting tool? | Excel Discussion (Misc queries) | |||
If Statement/Conditional Formatting | Excel Worksheet Functions | |||
=IF Statement formula or conditional formatting | Excel Worksheet Functions | |||
Conditional formatting based on if statement. | Excel Worksheet Functions |