Conditional Formatting if two cells equal 0

[Tashat]

Hello everyone

I have two columns, A1:A25 and B1:B25 with numbers in each cell.

Can someone help me with conditional formatting to highlight two cells IF the two adjacent cells both equal 0. For example, if A2 and B2 equal 0.

Many thanks in advance

 

[jasonb75]

Try using a rule formula of

=AND($A1=0,$B1=0)

applied to $A$1:$B$25.

Note that the rule formula should refer to the top row of the range that it is being applied to with the column absolute ($ sign) and the row relative (no $ sign).

 

[Tashat]

Try using a rule formula of

=AND($A1=0,$B1=0)

applied to $A$1:$B$25.

Note that the rule formula should refer to the top row of the range that it is being applied to with the column absolute ($ sign) and the row relative (no $ sign).

Hi Jasonb75. Thank you so much. That is perfect.