Y
Yunus
I have the following Conditional Format for =G20:CA100
=AND(G$1>=$D3,G42<=$E3) Cell is Green
but how do I amend this so that it is Green only of in column C the
Value is EH, but if it is TH it is RED
=AND(G$1>=$D3,G42<=$E3) Cell is Green
but how do I amend this so that it is Green only of in column C the
Value is EH, but if it is TH it is RED