Hi,
I'm a first time TechGuy user so here's my question. I have a column of data which contains cells with numbers and cells with text (not both together). I'm using conditional formatting to change the cells that contain numbers which meet certain criteria to red font. My problem is, how do I keep the text from changing color. I want the conditional formatting to ignore the cells containing text so they remain in black font. I don't know VBA language - I'm not that advanced. Appreciate anyone who can help me with this.
Thanks,
reporter1
Here's a sample from the column. I formatted numbers in the Total ACW column which are >=25.5 to appear in red font. I want the LVE to remain black but it changes to red when I format the column. The example doesn't show it but the LVE all turn to red font when I add the conditional format.
You're right! Thanks so much for the tip - it will save me alot of time in a few of my reports. I still can't figure out why the conditional formatting affects the text, but as long as this works I'm happy. You're no 'Villan' to me!!
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!