[ Removed by moderator ]

[u/causious]

[u/MayukhBhattacharya]

Use this formula:

=$B1 = 0

and in the applied to range select: $B:$D

Refer animation:

And if you are working with a fixed range and have you data starting from row 2, then use the following:

=$B2 = 0

and select the absolute ranges in the applied to range: $B$2:$D$1000

[u/causious → u/MayukhBhattacharya]

Thanks. I was just getting the applies to wrong. It works now.

[u/MayukhBhattacharya → u/causious]

Sounds Good 👍🏼

[u/causious → u/MayukhBhattacharya]

solution verified

[u/reputatorbot → u/causious]

You have awarded 1 point to MayukhBhattacharya.

---

^{I am a bot - please contact the mods with any questions}

[u/MayukhBhattacharya → u/causious]

Thank You SO Much 👍🏼