Conditional Format - Two Criteria
 

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

Conditional Format - Two Criteria
 

Try this

=AND(D236<C236,U236<C236)

Mike

"Bull" wrote:

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

Conditional Format - Two Criteria
 

On Jan 29, 11:45*am, Mike H wrote:
Try this

=AND(D236<C236,U236<C236)

Mike



"Bull" wrote:
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- Hide quoted text -

- Show quoted text -

WORKS GREAT, THANKS.

R/
BULL