Set of Conditional Formatting rules for whole column

in the Rule formula remove the $ between C and 3 so $C3

in the apply to just change the rownumber of G column to f.e. 3000

with the changed rule it will automaticly move a row down for validationrule
make sure the formula starts at same row as your apply to range.

see if you can change it yourself based on my description or upload an example file so I can show it in there.

als read up on absolute an relative cell references that will explain you the use of the $ signs

Sure,

have a look at the endresult.

- you need $ before C to make sure the validation rule only looks at column C and does not move over.
- you need to remove $ before 3 to make sure it test the row it is on.

Thank you very much. Just one more question. Can you give me a link and/or suggest a book to read about absolute an relative cell references.

Thanks

ofcourse

this link from microsoft itself but also

https://support.microsoft.com/en-us/...e-5f0d8d0baca9

or
https://edu.gcfglobal.org/en/excelfo...-references/1/ with a video

Hi carlmon. Thanks for reply.
When I run code first time it didn't work and no error. I add to second IF statement

Please Login or Register  to view this content.

and substitute If n = 0 Then to If n > 0 Then. But it Reset spreadsheet when I click Yes and reset when I click No. How to fix the problem?

Thanks

Please Login or Register  to view this content.

I debugged step by step. When I clicked button N=2 after loop For. May be need to say If n > 0 Then?

Thanks

Eugz, the idea with the N = N+1 was to say if there are no values in this range, N will = 0... if N = 0, then the message box will appear.

It looks like you deleted your original code, but you had the idea of... if this range is "" then show this message box.

By setting N>0, then you are effectively saying if this range isn't blank, then show the message box.