If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Formatting with if statement
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. |
#2
|
|||
|
|||
Conditional Formatting with if statement
Why do you want to use an IF statement? Conditional formatting wants a
condition that returns TRUE or FALSE. Use CF/ Formula Is/ =AND(B2="",OR(B1="Jan",C1="Feb",D1="Mar")) Choose your coloured format. -- David Biddulph "stoz" wrote in message ... 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. |
#3
|
|||
|
|||
Conditional Formatting with if statement
Select A2 then Format
CFFormula is: =B2="" Select red font and OK. Gord Dibben MS Excel MVP On Wed, 7 Oct 2009 12:26:01 -0700, stoz wrote: 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 | |
Display Modes | |
|
|