Hi BRout,

It is easier than you think, follow the images below to do what you need to do:

NOTE: Make sure that Cell A1 is written as A1 and not $A$1 or will only be effective for that cell, you can put in whatever reference you want however make sure that you enter the upper left cell that you want the formatting to apply to, Excel will automatically adjust for each cell.

ConF1.jpg

ConF2.jpg

adjust the settings on the second column to the range of cells you want to have the formatting. (In the example I have put A1 through to H100, but you may well have a smaller or larger area you want to cover.