conditional formating

[roninn75]

hi
i am highlighting a cell based on the adjacent cell value. i am achieving this by using the formula: =LEN(C5)>0 in D5 using conditional formula.

My question is however, when I now enter text into D5, how do I remove the cell highlighting that was applied? basically, the conditional formatting is fired when cell C5 has a value in it so D5 is highlighted. the rows are banded just as a matter of interest.

thank you for your assistance.

[HansV]

I'm sorry, I don't understand your question.

Conditional formatting will overrule directly applied formatting. What exactly do you want to remove?

[roninn75]

when cell C5 has no text in it, then c5 and D5 has no highlighting except for the banded rows.

when text is entered into C5, then D5 will be highlighted (yellow)
when text is entered into D5, then the highlighting is removed and the cell reverts to its original banded row colour.

[HansV]

You could use this formula in the conditional formatting rule of D5:

=AND(C5<>"",D5="")

[Rudi]

Maybe this modification?

=AND(LEN($C5)>0,ISBLANK($D5))

[roninn75]

Thanks guys

with both formulae when i enter text in C5 , cell D5 colour changes to yellow. (D5 is blank) this is correct
if i delete the text in C5 the colour in D5 reverts. this is also correct.

however, if there is text in C5 and i enter text in D5, the colour should now revert. this does not happen though

[Rudi]

however, if there is text in C5 and i enter text in D5, the colour should now revert. this does not happen though

It seems to be working for me...Cell C7 and D7 has text and the formatting reverts (is removed).

Image 15.jpg

[roninn75]

sorry Rudi i forgot to delete the previous rule... my apologies. this works :)

[Rudi]

Ah...