Hi,

Windows XP fully updated
Excel 2002 sp3

is there a way to make a cell's background colour change depending upon
the contents for ANOTHER cell.

E.G.

if cell A1 contains the word 'done' I would like the background colour
of B1 to be yellow.

Conditional formatting only seems to work on the cell in question not on
another cell.

Thanks

--
Nospam

This question appears as unanswered in my OE, so excuse me if this is an
extra, unneeded reply.

Select B1, then use CFR with the Custom option, with a formula that returns
TRUE or FALSE

IF A1 will just contain the exact word:

=A1="Done"

If it will contain a string that will have the word 'done'
=NOT(ISERROR(FIND("done",LOWER(A1))))

Of course, you might need further checks to differentiate between

"I'm done with this"

and

"I'm not done with this"

--
HTH,
Bernie
MS Excel MVP


"Nospam" wrote in message
...
Hi,

Windows XP fully updated
Excel 2002 sp3

is there a way to make a cell's background colour change depending upon
the contents for ANOTHER cell.

E.G.

if cell A1 contains the word 'done' I would like the background colour of
B1 to be yellow.

Conditional formatting only seems to work on the cell in question not on
another cell.

Thanks

--
Nospam

In message , Bernie Deitrick
writes

Thanks.

I will go and try this.

Thanks again.



This question appears as unanswered in my OE, so excuse me if this is
an extra, unneeded reply.

Select B1, then use CFR with the Custom option, with a formula that
returns TRUE or FALSE

IF A1 will just contain the exact word:

=A1="Done"

If it will contain a string that will have the word 'done'
=NOT(ISERROR(FIND("done",LOWER(A1))))

Of course, you might need further checks to differentiate between

"I'm done with this"

and

"I'm not done with this"


--
Nospam