Solved Excell 2003 issue (Letter = Couolor)?

March 25, 2013 at 07:48:11
Specs: Windows XP
I'm very new to excell and I am trying to make a cell show a different back ground colour if i enter a letter in to it. Eg, by tiping in 'a' the cell would turn, red, or 'b' it would turn green? I want to do this for quite a large table and want the rule to apply for every cell, how can i do this?

See More: Excell 2003 issue (Letter = Couolor)?

Report •

March 25, 2013 at 08:56:01
✔ Best Answer
This can be done with Conditional Formating (CF) but in Excel 2003, you are limited to 3 CF's per cell. If you need more than 3, you'll need to use a macro.

To apply up to 3 CF's to a range, follow these steps:

1 - Select the entire range
2 - Choose Format...Conditional Formatting
3 - Cell value...Is equal to...="A"
4 - Click Format...Patterns Tab...Choose a Fill Color...OK
5 - Click Add
6 - Cell value...Is equal to...="B"

The CF will be applied to each selected cell, individually.

In 2010, you can have many more CF's per cell.

If you need more than 3 fill colors, please provide the details and we'll see if we can offer some VBA code (a macro) which will work for you.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

March 25, 2013 at 13:37:43
Thank you!
Thats brillant luckily I only need 3.

Report •

Related Solutions

Ask Question