ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   change the color of a cell as a function of the cell value (https://www.excelbanter.com/excel-programming/403933-change-color-cell-function-cell-value.html)

Gary F[_2_]

change the color of a cell as a function of the cell value
 
i would like to know if it is possible to set the color of a cell as a
function of the numeric value within the cell (say red, yellow green) and
then if I change the value have the color automatically update.

Thanks

John Bundy

change the color of a cell as a function of the cell value
 
You can, but i can't be much more specific without details. look into
conditional formatting or post details.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Gary F" wrote:

i would like to know if it is possible to set the color of a cell as a
function of the numeric value within the cell (say red, yellow green) and
then if I change the value have the color automatically update.

Thanks



All times are GMT +1. The time now is 06:11 PM.

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