Excel 2002 Conditional Formatting Questions 2

[Hakala]

Hi, Tek-Tippers!

I'm trying to get conditional formatting to work based on:
* Cell value is some specific text, such as "New Hire"
and (different cell, different formula)
* Cell has nothing in it

I'm having trouble tracking down what the formulas should be. I know some Access VBA but that syntax isn't working here. All the Help file has is math (does not equal 0, etc) which doesn't work either.

Do any of you know where I can find a good reference on what formulas are acceptable to Excel in the conditional formatting window?

Thanks!


Michelle Hakala

http://www.winebird.com/

 

[bluedragon2]

=AND(A1="New Hire",B1="")

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[SkipVought]

Hi,

VBA does not work in spreadsheet functions.

In CF, use Formula is rather than Cell Value is.

Use spreadsheet function notation like...
[tt][highlight]
=AND(A1="Hew Hire",OtherCellRef=your other formula)[/highlight]
[/tt]


Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[Hakala]

Thank you both!

Michelle Hakala

http://www.winebird.com/