Good morning all i hope everyone is well.
Attached is a sheet i cannot for the life of me figure out how to get working, hoping some of you may be able to assist.
The Data sheet (image 1) is updated each day by an operative to show a return for a specific duty. The start time column is when they have sent the data to the sheet (auto added from a flow) and the Unit column is the name of the building. In the Dashboard sheet is a matrix showing each building and the date, im looking to have the date box coloured say green whenever the Data sheet recieves a new entry with the date from the start time column in data sheet relating to what building has been done. So basically when a new date is entered the corresponding unit name has the date highlighted in the box...does this make sense ?
i hope someone can assist....huge thanks in advan
ce, if poss im wondering if this can be done without any vba code?
Attached is a sheet i cannot for the life of me figure out how to get working, hoping some of you may be able to assist.
The Data sheet (image 1) is updated each day by an operative to show a return for a specific duty. The start time column is when they have sent the data to the sheet (auto added from a flow) and the Unit column is the name of the building. In the Dashboard sheet is a matrix showing each building and the date, im looking to have the date box coloured say green whenever the Data sheet recieves a new entry with the date from the start time column in data sheet relating to what building has been done. So basically when a new date is entered the corresponding unit name has the date highlighted in the box...does this make sense ?
i hope someone can assist....huge thanks in advan
