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
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? |
#2
|
|||
|
|||
conditional formatting
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 FormatConditional FormattingCondition 1Formula Is =AND(F10,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. =F10 and I1 = "" When I click OK, I get an error. What is the error? |
Thread Tools | |
Display Modes | |
|
|