CODEWITHSUNDEEP
excelexcel-formulaconditional-formatting
likethevegetable
likethevegetable

Reputation: 304

Excel Conditional Formatting - format cell based on row number AND formula

I'm trying to conditionally format cells individually that are above a certain value AND on an even row number. I can perform these tasks separately, but the AND function will not work. I believe it is due to Excel trying "compute" a range comparison inside the AND, and it produces 0.

Here is an image of what I'm trying to achieve: enter image description here

Upvotes: 0

Views: 1469

Answers (1)

basic
basic

Reputation: 11968

Use formula

=AND(B2>0.5,MOD(ROW(),2)=0)

and apply to range $B$2:$C$4

enter image description here

Upvotes: 1

Related Questions