What results is it producing? I think you are having difficult with the
portion...
AND(AS7="Yes",AF7="",K7<"X",K7<"*")
And my guess is that it is K7<"*", is it suppose to be an asterisk?
you might try changing it to K7<CODE(42)

If this doesn't help, respond back and describe which conditions work, and
which ones don't.
--
John C


"Gary" wrote:

I'm using nested conditions as follows:
=OR(AND(F7="Y",K7=""),AND(H7="Y",K7=""),AND(AS7="Y es",AF7="",K7<"X",K7<"*"),AND(I7="$",AF7="")),
where if the conditions (AND(F7="Y",K7="") are true cell turns red, or if
the second conditions are true AND(H7="Y",K7="") the cell turns red, etc. ie,
I want each "AND" condition to be evaluated separately, so if any of the AND
conditions are true the cell will turn red. I must have my ( ) in the wrong
combinations because the formula does not produce my expected results.