coloradoprincess78
New Member
- Joined
- Oct 31, 2016
- Messages
- 14
There is something simple that I am missing here, but can't take any more time googling it
Applied conditional formatting to Column I to change font color to white when Adjacent Cell in Column H has no value. H contains a formula.
Conditional formatting formula is =$H2=" "
Here is what it is doing, and it sort of works - for some reason on my screen I16 is white. And will not turn to black until i have something in H17 - which is slightly counterproductive.
Excel 2010
<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Applied conditional formatting to Column I to change font color to white when Adjacent Cell in Column H has no value. H contains a formula.
Conditional formatting formula is =$H2=" "
Here is what it is doing, and it sort of works - for some reason on my screen I16 is white. And will not turn to black until i have something in H17 - which is slightly counterproductive.
Excel 2010
H | I | |
---|---|---|
1 | State Abbreviation | Number |
2 | AZ | 0100 |
11 | CA | 0101 |
12 | CA | 0102 |
13 | AZ | 0102 |
14 | AZ | 0103 |
15 | ND | 0100 |
16 | TX |
<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Site Numbering
Any suggestions are greatly appreciated, I've tried 10+ different formulas already , but this is one is the close as I can get it. Thanks in advance!