lad
10-12-2007, 01:20 AM
Hi,
I'm having trouble with what looks to be a quirk with conditional formatting.
I've created a formula in Column D of my worksheet that basically checks the values of numbers in Column C. If the number is above a certain value but below another value it changes the text of the cell in Column D to amber, if below a certain value it changes it to red.
In Column D I have used a webding font character (108) to insert a solid circle in every cell.
This works great except the amber and red look a little similar so I wanted to change the amber to a another colour. However, when I edit the conditional format rule to another font colour (that's all I change), the colour changes fine, but it also changes the font in all the relevant cells to a "|" instead of the solid circle!?!?
It's as if the font is removed. If I click on an affected cell a see in the little window bar where formulas usually pop up (sorry, forgot what it's called) a "|" symbol. Fair enough, however if I click on one of the cells what has the unaffected circle symbol in I also see a "|" in the formula window !!!
Confused!!
Any ideas anyone as to why this happens?
Cheers.
I'm having trouble with what looks to be a quirk with conditional formatting.
I've created a formula in Column D of my worksheet that basically checks the values of numbers in Column C. If the number is above a certain value but below another value it changes the text of the cell in Column D to amber, if below a certain value it changes it to red.
In Column D I have used a webding font character (108) to insert a solid circle in every cell.
This works great except the amber and red look a little similar so I wanted to change the amber to a another colour. However, when I edit the conditional format rule to another font colour (that's all I change), the colour changes fine, but it also changes the font in all the relevant cells to a "|" instead of the solid circle!?!?
It's as if the font is removed. If I click on an affected cell a see in the little window bar where formulas usually pop up (sorry, forgot what it's called) a "|" symbol. Fair enough, however if I click on one of the cells what has the unaffected circle symbol in I also see a "|" in the formula window !!!
Confused!!
Any ideas anyone as to why this happens?
Cheers.