Crispyboggins
New Member
- Joined
- Jul 28, 2019
- Messages
- 5
Morning,
I have a spreadsheet Training Matrix with multiple columns. In colum D is has the value of 1 if training has been completed or 0 if not completed. In colum E there is a option for the date of training. Column D is updated from another sheet so what i need to do is for the coresponding cell in column E to change colour if no date is entered so the Training Officer knows that a date needs to be entered. E.g if D5 was 0 E5 will do nothing but is D5 is 1 and E5 is blank E5 will turn RED
I have a spreadsheet Training Matrix with multiple columns. In colum D is has the value of 1 if training has been completed or 0 if not completed. In colum E there is a option for the date of training. Column D is updated from another sheet so what i need to do is for the coresponding cell in column E to change colour if no date is entered so the Training Officer knows that a date needs to be entered. E.g if D5 was 0 E5 will do nothing but is D5 is 1 and E5 is blank E5 will turn RED