My problem is based around an excel sheet being used to produce rotas which are then stripped to submit payroll hours.
There are names of people on this payroll sheet and next to the names in the cell to the right are the hours they have done.
I’ve used the conditional formatting tab on excel so that if the hours section next to the name has been left blank then the cell turns red.
However not all areas of the rota have names in the cells and i don’t want most of the sheet to be coloured red.
Is it possible to to combine this conditional formatting with a rule where the cell only turns red if there is actually data in the cell to the left of it. For example an employees name?