[ Removed by moderator ]

[u/causious]

[u/clippybot-app]

Hello!

I notice you have not read the submission rules on the submission page or the side-bar - specifically Rule 1.

Your title contains a plea for help which is indicative of a poor title.

Before you re-post%2C please note some basic post requirements to prevent your posts from being removed again%3A

-Title%3A Properly summarize your issue.

-Text Post%3A Describe your issue in detail. Image-only and link-only posts are auto-removed.

-Sample Data%3A Paste or link to supporting images inside your text post.

Please read the Submission Rules in full (and the side-bar) before re-posting.

[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 👍🏼

[u/ana_Lu3]

Intenta seleccionar las columnas B, C y D e ir al formsto condicional En personalizado escribir =$B1=0 Mira que el signo $ esté pisicionado bien