formatconditional formattingformula

--
Don Guillett
SalesAid Software

"dsg " wrote in message
...
I would like to set the color of the different cells depending on
what value that is in the cell.

Let's say, it should search in the range ("A1:H40") and
depending on what number it is in each field it get different
cellcolor.
ex. if the cell A5 = 50 it should get a blue background.



Any suggestions ?
All this is going to run inside a macro.


---
Message posted from http://www.ExcelForum.com/