Formula or macro

[Fraserj]

I have a cell H5 which the amount is changeable dependent on the day. In column b I fill these cells with numbers from 1-20 but need it to give me some sort of notice to remind others that we have reached whatever number is in Cell H5 (and multiples of that number) e.g H5=70....70, 140, 210,280 etc will flag up to say.
These flags can be with notes, colours whatever it takes just noticable. If someone could help that would be great

 

[Fluff]

How about conditional formatting that would colour the cell if it's a multiple of H5, would that work for you?

 

[Fraserj]

How about conditional formatting that would colour the cell if it's a multiple of H5, would that work for you?

I'm happy with that... but sometimes the number wont actually be 70... it might be 72 or something like that. Then I need it to only colour on that one cell. I hope that makes sense, as it could end up being 70 on the 1st cell that is completed or on the 70th cell, just random dependent on the situation unfortunately

 

[Fluff]

Ok select col B from the first row, to the last row you want this to work on > Conditional formatting > New rule > use a formula > enter
=AND(B1<>"",MOD(B1,$H$5)=0)
Select your format > Ok
Change the B1 to the first selected cell in the region you selected.

Book1
	B						H
1	11
2	1
3	33
4	10
5	11						13
6	12
7	13
8	14
9	15
10	16
11	17
12	18
13	19
14	20
15	21
16	26
17	25
18	39
19	60
Data

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1:B28	Expression	=AND(B1<>"",MOD(B1,$H$5)=0)	text	NO

 

[Fraserj]

Ok select col B from the first row, to the last row you want this to work on > Conditional formatting > New rule > use a formula > enter
=AND(B1<>"",MOD(B1,$H$5)=0)
Select your format > Ok
Change the B1 to the first selected cell in the region you selected.

Book1
	B						H
1	11
2	1
3	33
4	10
5	11						13
6	12
7	13
8	14
9	15
10	16
11	17
12	18
13	19
14	20
15	21
16	26
17	25
18	39
19	60
Data

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1:B28	Expression	=AND(B1<>"",MOD(B1,$H$5)=0)	text	NO

If the number in cell B became higher than 13... say 15 and there was no 13 would it still light up Green? Cell b numbers will all add together from cell a ..

2	2	Multiples of 13
3	5
7	12
3	15 (I'd want this green)
8 3	23 26 (also green)

Sorry for the hassle

 

[Fluff]

Select B2 downwards and use this formula
=AND(B2<>"",MOD(B2,$H$5)<MOD(B1,$H$5))

 

[Fraserj]

Select B2 downwards and use this formula
=AND(B2<>"",MOD(B2,$H$5)<MOD(B1,$H$5))

Thank you... appreciate it

 

[Fluff]

You're welcome & thanks for the feedback