I am trying to copy conditional formatting across the whole worksheet.
The conditional formatting is based on 2 cells, 1 cell which will say either 'on-hire' or 'off-hire' and the other cell with a date.
I have created a formaula in which if the column says 'off-hire' and the date column is older than today's date then the whole row will turn red.
I want to copy this across the whole worksheet without manually entering the conditional formatting for each row.
I've tried the ways I've seen online using the formatting painter etc. but it doesn't seem to work.
Does anyone on here have any solutions?