Hello.
I Used this site yesterday for the first time and was impressed by the speedy and accurate response. So a big thank you for that.
Now onto my new issue.
I have a spreadsheet to keep track of deliveries made. For each delivery i have to request proof of delivery. Each delivery has a unique identifier. What i want to be able to do is have column A with the unique identifiers, B C & D filled with other vital info. In column G i want to able to type in the identifying numbers for all the jobs in which i have requested and if a match is found in Column A i'd like to colour it yellow. In column H i'd like the same formula but to colour the column A cell red. Meaning i can quickly see which Proof of deliveries i've requested and which ones i've recieved.
Could anyone help me with this please
Thank you in advance
Ricky Coales
I Used this site yesterday for the first time and was impressed by the speedy and accurate response. So a big thank you for that.
Now onto my new issue.
I have a spreadsheet to keep track of deliveries made. For each delivery i have to request proof of delivery. Each delivery has a unique identifier. What i want to be able to do is have column A with the unique identifiers, B C & D filled with other vital info. In column G i want to able to type in the identifying numbers for all the jobs in which i have requested and if a match is found in Column A i'd like to colour it yellow. In column H i'd like the same formula but to colour the column A cell red. Meaning i can quickly see which Proof of deliveries i've requested and which ones i've recieved.
Could anyone help me with this please
Thank you in advance
Ricky Coales