Steve

Thanks for the reply.
I have a column of entries in column C. All entries are integers from 1 to
5. I wish to format Column A based upon the entries in Column C.

If the entry in cell C is "1" then format cell in column A background RED
forground WHITE.

If the entry in cell C is "2" then format cell in column A background GREEN
forground BLACK.

If the entry in cell C is "3" then format cell in column A background YELLOW
forground BLACK.

If the entry in cell C is "4" then format cell in column A background BLUE
forground WHITE.

If the entry in cell C is "5" then format cell in column A background LIGHT
GREY forground BLACK.

Many thanks
Simon


Simon,

If you could describe your 5 variations and what you would like the
cell formatted as for each it would be helpful. Will each variation
produce a unique formatting? If multiple variations will result in the
same format, CF may work for you using formulas.



Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=504882