Why do you need a macro? Why not use Conditional Formatting?
With Conditional Formatting:
Select your entire range, i.e. A1:IV101
Click on Format, then Conditional Formatting
Under Condition 1, change Cell Value Is to Formula Is and put in the following formula:
Click on Format
Click on Patterns
Select a color