Conditional Format IF statement

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Cobditional Formatting Rows based on dates in action plan. 0
Conditional Formatting to Another Cell 0
Conditional Formatting 1
Conditional Formatting 0
Conditional Formatting with VBA 4
Conditional format question 4
Excel 2010 Conditional Formatting 2

Top