New Conditional Format Overriding Previous Conditional Format
 

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

New Conditional Format Overriding Previous Conditional Format
 

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?

New Conditional Format Overriding Previous Conditional Format
 

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

New Conditional Format Overriding Previous Conditional Format
 

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