Multiple conditions in Conditional Formatting

G

guilbj2

I'm currently using the following as conditions 1 and 2 for a custom
format that alternates the shading every other line.

What I can't figure out, is how to add another condition. Basically, I
want to check column M for a Y or N value. If Y if present, I want the
text to be green. If a N is present, red text.

I can do the Y/N bit just fine, but can't seem to do it at the same
time as the alternating shading.

=MOD(SUBTOTAL(3,OFFSET(A$8:A4,0,0)),2)=0
=MOD(SUBTOTAL(3,OFFSET(A$8:A4,0,0)),2)=1
 

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

Conditional Formatting 0
change the rows value based on conditions 0
Formatting cell 2
Conditional Formatting 4
Conditional Formatting 3
Conditional Formatting 1
alternate row shading kept with autofilter 3
Macro for alternate conditional formatting? 0

Top