color notification

[reza]

Hi All...

me again....
i want if i update progress in some cell, that cell with have a new color?
for example in C14 already have values 10% and if i update that progress,
fill of that cell will have a new color, maybe yellow or green.
can excel do that,..

thanks again

 

[RonaldoOneNil]

Look at conditional formatting of that cell based on its value.
In Excel 2003 it is on the under the format menu.

 

[Jacob Skaria]

Check out the below link on Conditional Formatting
http://www.contextures.com/xlcondFormat01.html

If this post helps click Yes