New Conditional Format Overriding Previous Conditional Format

  • Thread starter Thread starter Rene
  • Start date Start date
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?
 
Simply change the "conditional format" of C6. (Format, Conditional
formatting on the main minu)
 
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

2 FORMULA IN 1 4
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
Using two different formats for one cell. 1
Move cell info and info in neighboring cell on new entry 6
Excel Time Rounding in Excel 2
Two conditions in one cell. Help needed ASAP 3
Double Negative Problem 1

Back
Top