Probably an easy one
I need to create a conditional format where when for example-
the cell A1 will change to yellow if a certain date is exceeded
but here is the query - I then need the next 5 cells below cell a1 to automatically change to the same colour as cell A1 regardless of their content
thanks
C
I need to create a conditional format where when for example-
the cell A1 will change to yellow if a certain date is exceeded
but here is the query - I then need the next 5 cells below cell a1 to automatically change to the same colour as cell A1 regardless of their content
thanks
C