applying conditional formatting on empty cell

[Tom Ossieur]

Hello,

for "conditional formatting" the condition applies to the
contents of that specific cell.

BUT, is it also possible to apply conditional formatting,
referring to the contents in an other cell?

example:
I'm writing a small program. The cells to be filled in are
yellow. However, when a specific cell is filled in, a
certain question is not relevant anymore and the related
cells should change colour from yellow to white (so that
it's clear they shouldn't be filled in).

So:
IF value of cell C10=1 THAN FORMAT cell D10 changes to
white and is not to be filled in,
IF value of cell C10=0 or empty THAN FORMAT cell D10 stays
yellow and can be filled in

Can someone say me whther this is possible and how?

Many thanks in advance!

Tom

 

[Frank Kabel]

Hi
try the following (a combination of conditional format and data
validation)
- select cell D10
- goto conditional format and enter the following formulas:
=C10=1 -> choose a white format
=OR(C10=0,C10="") -> choose a yellow format
- finish conditional format

- goto 'Data - Validation' and enter the following formula (category:
'Custom')
=OR(C10=0,C10="")
- finish data validation

 

[Guest]

Hello Frank,

Many thanks once again for your valuable help!

Tom