ExcelBanter - How do i make a cell change color depending on the value being in.

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How do i make a cell change color depending on the value being in. (https://www.excelbanter.com/excel-programming/319402-how-do-i-make-cell-change-color-depending-value-being.html)

HVN

How do i make a cell change color depending on the value being in.

I'f like to have cells automatically change color depending on what is being
inputted. For example, if 1 is entered, it will be gree, if 0 then red.

Frank Kabel

How do i make a cell change color depending on the value being in.

Hi
use 'Format - Conditional format' for this

--
Regards
Frank Kabel
Frankfurt, Germany
"HVN" schrieb im Newsbeitrag
...
I'f like to have cells automatically change color depending on what is
being
inputted. For example, if 1 is entered, it will be gree, if 0 then red.

All times are GMT +1. The time now is 02:00 AM.