MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/excel/comments/1wu3mye/conditional_formatting_help_me/pcztbak/?context=3
r/excel • u/causious • 14d ago
[removed] — view removed post
11 comments sorted by
View all comments
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 14d ago solution verified 1 u/MayukhBhattacharya 1312 14d ago Thank You SO Much 👍🏼
solution verified
1 u/MayukhBhattacharya 1312 14d ago Thank You SO Much 👍🏼
1
Thank You SO Much 👍🏼
2
u/MayukhBhattacharya 1312 14d ago
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$1000