Page 1 of 1
CF zero
Posted: Fri Nov 26, 2021 1:02 pm
by sna
Hi Dear
I need your help how to highlight cells for consecutive zero Without using helper column
I attach a sample for your reference
(With helper column)
Thank
Re: CF zero
Posted: Fri Nov 26, 2021 2:50 pm
by Supachok
can we use
"conditional formatting"
Set criteria = 0
then define your display color
Re: CF zero
Posted: Sat Nov 27, 2021 9:21 am
by sna
no I try this by my own before I post here
Re: CF zero
Posted: Sat Nov 27, 2021 9:26 am
by sna
the solution you suggest would color all zeros,i mean consecutive zero by rows
Re: CF zero
Posted: Sat Nov 27, 2021 10:23 am
by snasui
Please try this conditional formatting procedure,
- Select A2:J8
- Use this formula in 'Format values where this formula is true' as picture below
=IF(COLUMNS($A2:A2)=1,A2=0,OR(A2&OFFSET(A2,0,-1)="00",A2&B2="00"))
Re: CF zero
Posted: Sat Nov 27, 2021 12:49 pm
by sna
as great as always.thank you