Conditional Format - Two Criteria

[Bull]

I have this in my conditional format box:
="D236<C236 & U236<C236"

If the above is true, I want the cell to be shaded green.

It is not turning green, and I checked and it should be, can someone
point me in the right direction here?

Thanks folks.

Bull

 

[Mike H]

Try this

=AND(D236<C236,U236<C236)

Mike

 

[Bull]

Try this

=AND(D236<C236,U236<C236)

Mike









- Show quoted text -

WORKS GREAT, THANKS.

R/
BULL