Conditional Formatting with Macro

Hi,
l want to do conditional formatting rule with macro for multiple sequences.
Example

Please Login or Register  to view this content.

If "S25" is equal to "0" or blank cells; C25: N47 in the block, text and background (fill) "white" color, borders the "No" I want to do.
If "S25" is not equal to "0" or full, C25: N47 in the block will return back.

I tried to write the code but did not.

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Sorry my bad English.
Thanks for your helping.

Hi, AlphaFrog
Code is working properly. There is only one mistake.
This Code:
Formula1:="=$S$" & i + 25 & "=0"

"S26" and the others working good but "S25" is not working properly for i=1 to 99.

Please Login or Register  to view this content.

When l enter a value in "S25", it is not working. But the other "S26,S27,S28......" is working properly. (May be "i" starting from 1 in this code (Formula1:="=$S$" & i + 25 & "=0").)

Hi, AlphaFrog
The problem was solved.

Working Code:

Please Login or Register  to view this content.

And The other macro with commandclick button. (*** I could not do macro when button pressed with the above code. Therefore a long macro appeared.)

Please Login or Register  to view this content.