Stefi

You're a genius. Perfect thank you

"Stefi" wrote:

Select range say A1:T10 (adjust T10 as required)
Formula for condition1
=$D2="completed"
choose yellow
Formula for condition2
=$D2<""
choose green

Regards,
Stefi

€žWanna Learn€� ezt Ã*rta:

This is what I'm trying to accomplish: when the word "completed" appears
in column D I want the that ROW (lets say a1 to T1) to be highlighted in
yellow,if another word appears on that cell then highlighted in green

I tried conditional formatting - Cell value is - and of course it only
highlights one cell. I also tried conditional formatting using" formula is"
and that is where I'm having dificulties. 'm stuck... someone help me please
thanks