DEar Bob

Thank you what I am after is some code for VBA to turn a cell a certain
colour if a certain letter is typed. Conditional formatting is great but does
not help if you have more than thfree conditions.

For Example ig I type a H I want it to turn the cell green, Bh turn the cell
pink S turn yellow md L turn the cell Red

Thanks Joel
--
N/A


"Bob Phillips" wrote:

Use a default colour for all the cells, then just add 3 condition formats.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Joel" wrote in message
...
Hi I have three countif statements in my Excel spreadsheet that use
conditional formatting but I need to add a fourth but of couse Excel only
allows three. How can I get around this.

Thank you in advance
--
N/A