Question

[dirtytongue]

If possible...
How do I get excel to change the color of a "grid" if I enter say
specfic letter or word in it.

Example.

800 columns by 800 rows
All columns and rows are small as possible
Each letter would mean something, and I would need the grid with tha
letter to be a specifc color.
To allow easy viewing of the information

V = red
R = grey
H = blue

So instead of filling in each color per grid myself, I would get exce
to auto-fill

Any help would be greatly appreciat

 

[Pete_UK]

You could use conditional formatting for this. Select all 800 x 800
cells, then Format | Conditional Formatting, and in the panel that pops
up enter Cell Contents is equal to V, then click on Format and the
Patterns tab (for background colour), then click red and OK.

While the panel is still displayed, click Add for another condition and
set up R for grey in the same manner, then Add again and set up H for
blue. A final OK will get you out of the dialogue box, then you can try
it out.

Hope this helps.

Pete

 

[Dave Peterson]

Format|Conditional formatting sounds like a possibility.

Debra Dalgleish has some hints:
http://www.contextures.com/xlCondFormat01.html