Please find attached the dummy excel to view the requirement.

Requirement:::
The color of cells should change based on the values in two other cell
(importance and rating).

Importance: This value determines the number of colored cells
Rating: This value determines the color of the cells

Pls. let me know how we can do this in VB or conditional formatting.
(requires more than 3 conditional formats)

Thanks
Aravin

Attachment filename: worksheet.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=65897
--
Message posted from http://www.ExcelForum.com