vary color

[bev]

can i vary the color of a cell according to its value?

thanks

 

[Andy B]

Hi

Have a look at Format / Conditional Formatting. Here you can set cells to
change their properties (colour, border) depending on certain criteria.
Here is a starter for you!!
http://www.contextures.com/xlCondFormat01.html

 

[Judy Freed]

Yes, you can do it with conditional formatting.

http://www.uncc.edu/sysdev/howtos/excel/using conditional formatting with numeric values.htm

Judy Freed
Systems Development
UNC Charlotte

 

[bev]

thanks thats really useful!

Hi

Have a look at Format / Conditional Formatting. Here you can set cells to
change their properties (colour, border) depending on certain criteria.
Here is a starter for you!!
http://www.contextures.com/xlCondFormat01.html