Change cell colour if condition not met

[robrobet]

I have this code work fine for me but I want if there is way to if condition are not met then those cell change to green colour. It is easy to understand but still some of them are not understand about F28 or I41. So I want to add little more in this macro so when macro run the cell colour change to green and message pop up then may be easier for some person to understand which cell they need to focus.
when macro end then these cell go back to normal colour

here is the code

Please Login or Register  to view this content.

[protonLeah]

Just use Conditional Formatting. Select cells F28 & I41 and enter the formula:

Please Login or Register  to view this content.

and choose your fill color.

[robrobet]

I want to make some kind alert for people who use this sheet to show in colour, when message pop up check the total match it also highlight those in cell in colour,as soon I hit ok on message box that change back to white. same thing for second alert pop up then it show range n8 to n14 in colour to which cell they need to fill out.

Thanks for advice and your time
RR

[protonLeah]

You should use Data Validation with Conditional Formatting:

[robrobet]

How I do chose Data Validation for range n8 to n14, I want if user fill g8 then they must fill n8, if g8 is blank then they can not put any number in n8.

[protonLeah]

That's a different problem from the original so you should start a new thread. Most members won't bother with a thread that's already been going on for several days.

[robrobet]

Thanks For reply
RR