Hi All,

I need to Conditional Format every cell in my work sheet. No matter which cell I click on...
1. if SUM of 'current cell' + '5 cells above and/or below' is > 60, make the cell red

This might be a circular reference, however, I thought Conditional Formatting would handle it...?

Can someone please advise how I would apply this Conditional Format to every cell?

What I've done so far...
After selecting 'every cell' in the work sheet, I've applied a Conditional Format something like this.

=if(SUM(or(OFFSET(address(row(),Column()),0,0,5,1))>60,(OFFSET(address(row(),Column()),0,0,-5,1))>60,),1,0)

This may or may not be the right way, but in any case it's not working for me...Any help would be greatly appreciated

Nelg