Excel font color problem

lon · Joined: 26 Apr 2005 Posts: 7

Hello. I have a problem with font color in Excel. I would like to make font color change automatic in certain cells. For example, if I write something in cell A6 I would like font color to be changed automatically from default black to red. Is there some way to accomplish this?

rusty · Joined: 13 Jun 2005 Posts: 8

Hi. You can solve your problem with Excel font color in two ways. You can write some VBA code and you can use feature called Conditional Formatting. I believe that second option is better for you, unless you are proficient with coding. Right click on cell you would like to have other font color, click formatting and then Conditional formatting. You can define condition for changing font color here easily.

H-Desk.com - PC Security matters - Protect your PC privacy

Excel font color problem

LIFEFORM SOCIAL COMMUNITY NETWORK