Excel Comparing Values
 

Hey people,

Im trying to build a spreadsheet that will allow me to compare values
between two sheets. One sheet has holiday requests on it and one sheet has
sickness days.

What im trying to do is if someone has been declined at holiday, but theirs
an entry on second sheet with sickness on the holiday sheet their will be a
box at the end which will turn red meaning theirs a sickness entry present.

Can anyone help????? I have included a wee example.