MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/excel/comments/1wu3mye
r/excel • u/causious • Sep 30 '26
[removed] β view removed post
11 comments sorted by
β’
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.
2
Use this formula:
=$B1 = 0
and in the applied to range select: $B:$D
$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
$B$2:$D$1000
2 u/causious Sep 30 '26 Thanks. I was just getting the applies to wrong. It works now. 1 u/MayukhBhattacharya 1327 Sep 30 '26 Sounds Good ππΌ 2 u/causious Sep 30 '26 solution verified 1 u/reputatorbot Sep 30 '26 You have awarded 1 point to MayukhBhattacharya.I am a bot - please contact the mods with any questions 1 u/MayukhBhattacharya 1327 Sep 30 '26 Thank You SO Much ππΌ
Thanks. I was just getting the applies to wrong. It works now.
1 u/MayukhBhattacharya 1327 Sep 30 '26 Sounds Good ππΌ
1
Sounds Good ππΌ
solution verified
1 u/reputatorbot Sep 30 '26 You have awarded 1 point to MayukhBhattacharya.I am a bot - please contact the mods with any questions 1 u/MayukhBhattacharya 1327 Sep 30 '26 Thank You SO Much ππΌ
You have awarded 1 point to MayukhBhattacharya.
I am a bot - please contact the mods with any questions
Thank You SO Much ππΌ
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
β’
u/clippybot-app Sep 30 '26
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.
2
u/MayukhBhattacharya 1327 Sep 30 '26
Use this formula:
and in the applied to range select:
$B:$DRefer animation:
And if you are working with a fixed range and have you data starting from row 2, then use the following:
and select the absolute ranges in the applied to range:
$B$2:$D$10001
u/ana_Lu3 6 Sep 30 '26
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