Have you tried using Conditional Formatting. You need to select all of the
cells as you are applying your conditional format.

"mobeer1958" wrote:

I am trying to set a color to a certain amount of cells after a date is
shown. I can get the cell that contains the date too but i cant get the rest
of the cells in that row too. any help in this would be much appreciated.