ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   color notification (https://www.excelbanter.com/excel-discussion-misc-queries/239614-color-notification.html)

Reza

color notification
 
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

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

"reza" wrote:

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


Jacob Skaria

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

If this post helps click Yes
---------------
Jacob Skaria


"reza" wrote:

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



All times are GMT +1. The time now is 09:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com