View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SuzyQ SuzyQ is offline
external usenet poster
 
Posts: 15
Default conditional formatting

I want to format column I (highlight cell) under the following condition
the value in same row column F is 0 and the cell in column I is empty. I
have put the following code in the formula bar for conditional formatting and
I'm getting an error. How do I fix the problem?

First I select column I, and then I select conditional formatting. Then I
change "cell value is" to "formula" and enter the following in the formula
box.

=F10 and I1 = ""

When I click OK, I get an error. What is the error?