I have a large spreadsheet - perhaps 50 cols. The cols are laid out in a way that matches the workflow - in order to help the staff populating the cells. Col Z is populated with the date that a key task has been completed. Cols AG and BA are similalry populated for two other key tasks. Obviously its easy to use conditional formatting to highlight and cells where a completion date has not been entered
Col A is populated with the identity of that particular project.
What I want to do is have the relevant cell in Col A automatically highlighted in the cells in any of Cols Z, AG or BA have been highlighted. This would allow me to scan down just one Col to spot any projects which have been highlighted as failing at least one of the 3 date checks.
Probably very easy for many on here - but not me (!) so thanks in advance