Conditional Highlighting in Numbers

[Winehouse]

Hi.
I’d like to highlight all cells that end in certain numbers, say 5,10,15,20 etc.
Rather than make a separate rule for each number, is there a way to group these together?
I believe there is a limit on how many rules you can make.

Regards

 

[Fluff]

How about

+Fluff 1.xlsm
	E
1
2	1
3	2
4	3
5	4
6	5
7	6
8	7
9	8
10	9
11	10
12	11
13	12
14	13
15	14
16	15
17	16
18	17
19	18
20	19
21	20
22
Lists

Cell Formulas
Range	Formula
E2:E21	E2	=SEQUENCE(20)
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E2:E21	Expression	=MOD(E2,5)=0	text	NO

 

[Winehouse]

Hi.
Sorry, meant to say I’m using Numbers, not Excel. Don’t think I can do that on Numbers.
Regards

 

[Fluff]

That is definitely something that you should have mentioned, you should also have posted in the General Discussion & Other Applications section. I have moved for you.

As I know nothing about Numbers I cannot help.

 

[Winehouse]

Apologies. Thank you.