Conditional formatting highlighting extra rows

2
votes

Having issues with conditional formatting highlighting additional columns and rows.If R=0 then the row should not be highlighted. Where did I go wrong?

enter image description here

1
google-sheetsgoogle-sheets-formulags-conditional-formatting
docs.google.com/spreadsheets/d/… Here you go – Mohamed Momin

1 Answers

0
votes

change your:

=$R2=0

into:

=$R5=0

UPDATE:

0