Highlight Cells using Spinbutton

[pwill]

Hi can anyone help with a formula?

I have a spin button form on sheet1 that increments the values by 1 in the linked cell "A3"

does anyone know a formula I can add to conditional formatting that will add fill colour to cells in range "D5:D26" each time the value in the linked cell "A3" increases by 1.

So if linked cell "A3" value is 0 then "D5" Fill colour is goes red then when the spin button increases the value in "A3" by 1 the Fill colour goes to the next cell in the range and "D6" would then be filled red instead of "D5" and so on...

ie

if "A3" = 0 then "D5" = red fill
if "A3" = 1 then "D6" = red fill
if "A3" = 2 then "D7" = red fill

Any help would be appreciated

regards

pwill

 

[BAlGaInTl]

Create a custom conditional format for Cell D5 with the following formula:

=(ROW()-5)=$A$3

Set the format to red fill.

Then select that cell and copy.

Then select D6:D26 and do a paste special "format"

 

[BAlGaInTl]

I just realized that because A3 is static... it's even easier.

Just select D5:D26 and create a new conditional format with that formula.

No need to copy and paste special.

 

[pwill]

Thank you BAlGaIl, that works perfect, much appreciated

pwill

 

[BAlGaInTl]

Your welcome, and thanks for the feedback.