Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

conditional cell format - alternate row color

20 views
Skip to first unread message

john taiariol

unread,
May 11, 2022, 2:13:57 PM5/11/22
to
Hello,
I have a column of numbers. sometimes the numbers repeat several times in adjacent rows. I would like to use conditional cell format (without the aid of a helper column) to distinguish between groups of numbers by alternating background cell color. similar to what is shown below:

background cell color
1406 remains white
6163 gray
6165 remains white
1412 gray
3209 remains white
3209 remains white
3209 remains white
3209 remains white
6164 gray
1408 remains white
1408 remains white
1408 remains white
2542 gray
2542 gray
2539 remains white
2539 remains white
7366 gray
7366 gray
7366 gray
7366 gray

thanks for any help

Claus Busch

unread,
May 11, 2022, 3:05:13 PM5/11/22
to
Hi John,
have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgfJhYSgBFp5cdAdv-w?e=z6TN9H


Regards
Claus B.
--
Windows10
Microsoft 365 for business

Adrian Caspersz

unread,
May 12, 2022, 6:30:03 AM5/12/22
to
On 11/05/2022 20:05, Claus Busch wrote:

>> 2542 gray
>> 2542 gray
>> 2539 remains white
>> 2539 remains white
>> 7366 gray
>> 7366 gray
>> 7366 gray
>> 7366 gray
>
> have a look:
> https://1drv.ms/x/s!AqMiGBK2qniTgfJhYSgBFp5cdAdv-w?e=z6TN9H
>
>

Clever!


--
Adrian C
0 new messages