In C6 I have the following formula =IF(E6="DONE",TRUE,FALSE), When "done" is
entered in E6, C6 turns into a certain pattern. I want C6 to revert to no
pattern when "done" is entered in E8. Is that possible? How?
--
Rene - Do appreciate your help

Simply change the "conditional format" of C6. (Format, Conditional
formatting on the main minu)

Rene wrote:

In C6 I have the following formula =IF(E6="DONE",TRUE,FALSE), When "done" is
entered in E6, C6 turns into a certain pattern. I want C6 to revert to no
pattern when "done" is entered in E8. Is that possible? How?

Use 2nd one as first cf
formula is =$e$8="done"
add
formula is =$e$6="done"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rene" wrote in message
...
In C6 I have the following formula =IF(E6="DONE",TRUE,FALSE), When "done"
is
entered in E6, C6 turns into a certain pattern. I want C6 to revert to no
pattern when "done" is entered in E8. Is that possible? How?
--
Rene - Do appreciate your help

I haven't seen the original question, but only Don's reply. I think what
the OP may be looking for is to change the formula in C6 from
=IF(E6="DONE",TRUE,FALSE) to =AND(E6="DONE",E8<"DONE")

[Note that the original =IF(E6="DONE",TRUE,FALSE) could have been simplified
to =E6="DONE", as that will return TRUE or FALSE without the IF function.]
--
David Biddulph

"Don Guillett" wrote in message
...
Use 2nd one as first cf
formula is =$e$8="done"
add
formula is =$e$6="done"

"Rene" wrote in message
...
In C6 I have the following formula =IF(E6="DONE",TRUE,FALSE), When
"done" is
entered in E6, C6 turns into a certain pattern. I want C6 to revert to
no
pattern when "done" is entered in E8. Is that possible? How?
--
Rene - Do appreciate your help