Excel 2003 Cell changes color when other cell is FALSE

[Chris Delsman]

Hi,

I am trying to make a cell change colors (red) when
another cell is false (0). For example

Cell A1 holds the text 'B'.

Cell D1 is '0'(FALSE) so Cell A1 should change colors to
RED.

This should also change back to regular color if cell D1
changes to '1' (TRUE).

If anyone has any ideas, it would really appreciate it!

Thanks,

Chris

 

[Norman Harker]

Hi Chris!

Use Conditional Format

Formula is:
=D1<>FALSE
Makes A1 Red unless D1 is the Boolean FALSE. Note that if D1 is
something other than TRUE or FALSE this will still leave A1 as being
Red.

If not using Boolean TRUE or FALSE you might use:

=D1<>1

A1 will be Red unless D1 is 1


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Tuesday 5th August 2003: Burkina Faso
(Independence Day), Croatia (Homeland Thanksgiving Day), Dominican
Republic (Santo Domingo Foundation Day), El Salvador (Transfiguration
San Salvador del Mundo), Peru (Virgen de las Nieves), Tuvalu (National
Children's Day). Observances: Hiroshima Day (23:15 UST 1945)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Geof Carrington]

-----Original Message-----
Hi Chris!

Use Conditional Format

Formula is:
=D1<>FALSE
Makes A1 Red unless D1 is the Boolean FALSE. Note that if D1 is
something other than TRUE or FALSE this will still leave A1 as being
Red.

If not using Boolean TRUE or FALSE you might use:

=D1<>1

A1 will be Red unless D1 is 1


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Tuesday 5th August 2003: Burkina Faso
(Independence Day), Croatia (Homeland Thanksgiving Day), Dominican
Republic (Santo Domingo Foundation Day), El Salvador (Transfiguration
San Salvador del Mundo), Peru (Virgen de las Nieves), Tuvalu (National
Children's Day). Observances: Hiroshima Day (23:15 UST 1945)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.



.
Norman

Fascinating - but why doesn't it turn green or pink or any
other colour? What determines RED?

Puzzled.

 

[Gord Dibben]

Geof

Norman missed a step or assumed that the step would be apparent to the poster.

Formula is =D1<>False

Format>Patterns>Red

Gord Dibben Excel MVP - XL97 SR2 & XL2002

 

[Jeremy]

Could you include the exact code. I tried typing this in a
cell and it does not work.
JJ