IF Statement JER
What is JER? Is that just a string of letters?
If so, you need to quote it:
=IF(Sheet1!B7="H","JER","")
To color the cell you have to use conditional formatting. Use the Formula Is
option and this formula: =J7="JER"
--
Biff
Microsoft Excel MVP
"Workbook" wrote in message
...
I am trying to create an IF Statement so that
Objective 1: If I enter "H" in cell B7, JER will appear in cell J7
Objective 2: J7 will turn yellow when JER appears in it.
Objective 1: This is what I have so far =IF(Sheet1!B7="H",JER,"").
However
when I enter a "H" in cell B7, J7 says #Name?
Objective 2: I know how to set this up with conditional formatting but I
am
wondering if it's possible to include this in the IF statement first.
What do you think?
|