Prev: Unique Values, not Unique Records
Next: Excel Column Renumbering Question
From: SuzyQ on 12 May 2010 11:39
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.

=F1>0 and I1 = ""

When I click OK, I get an error. What is the error?
From: Ms-Exl-Learner on 12 May 2010 11:46
Place the cursor in I1 cell and press Cntrl+Spacebar and now the Column I
will be getting selected. I1 should be the active cell (Active Cell will
have a white Background after selection also). Extend your selection by
holding Shift+Down Arrow upto your desired row.

Excel 2003:-
Select Format>>Conditional Formatting>>Condition 1>>Formula Is>>
=AND(F1>0,I1="")
Then Click the Format command button and choose your desired Font and
Pattern colour and give Ok…

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"SuzyQ" wrote:

> 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.
>
> =F1>0 and I1 = ""
>
> When I click OK, I get an error. What is the error?
 | 
Pages: 1
Prev: Unique Values, not Unique Records
Next: Excel Column Renumbering Question