New Conditional Format Overriding Previous Conditional Format

R

Rene

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?
 
B

Bob I

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

David Biddulph

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.]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with formula 7
Using two different formats for one cell. 1
The specified formula cannot be entered because it uses more levels of nesting than are allowed in t 7
Conditional Format a cell that contains a function 1
Move cell info and info in neighboring cell on new entry 6
Double Negative Problem 1
greater than, less than, and in between 4
Two conditions in one cell. Help needed ASAP 3

Top