Conditional formatting based on 2 different conditions

[craigg3]

I need to highlight(green) row B-R if the row number is odd which works.=MOD(ROW(),2)=1

I also need it to strikethrough row B-R if cell R has anything in it but the first condition takes away me being able to do strikethroughs unless the row is even.

Anyway to get both? Thanks.

 

[Legacy 167133]

Have you tried to move the second CF Rule to the Top of the Rules?

 

[craigg3]

No, I have not tried that. I will give it a try. Also forgot to mention this is for Excel 2003 version.

 

[craigg3]

Have you tried to move the second CF Rule to the Top of the Rules?

I tried, this did not work.