How to highlight four cells a number of cells away from a reference cell

Hi, 

Is it possible to highlight cells a specified number of cells away from a reference cell?  the specified number of cells away would be the value of the reference cell.

 

The reference cell changes every time it calculates.  So when it calculates 5 for example, I would like it to count across 5 cells away from the reference cell and then highlight that cell.  If it calculates 10, then it counts away 10 cells and highlights. 

 

Could anyone help me with some function name for this as I have trawled the web looking for a similar code but coudlnt find anything on this.  Is it possible with conditional formating?

 

Thanks

By: John Kijak

Leave a Reply

Your email address will not be published. Required fields are marked *