Colour a cell based on the date in a different cell

[amysh]

Hello,

I am looking for a way to grey out a cell in a particular column based on the date in another column on the same row. Basically I am creating a training log database and if someone has completed one particular training they do not need to complete another type. I need the expiry date of the training in the cell so each persons result will be different as opposed to just yes or no. Is this possible?

 

[Joe4]

Yes, you should be able to do this pretty easily with Conditional Formatting, using the "Formula" option to reference the other cell.
If you need help setting that up, please provide us with the specifics needed to write the formula.

 

[amysh]

I have worked out a way to grey one out now if the other has a date however it doesn't grey out where one side is blank. Any advise how I can include blanks please?

 

[Joe4]

I have worked out a way to grey one out now if the other has a date however it doesn't grey out where one side is blank. Any advise how I can include blanks please?

If you want to check if a cell, like say A1, is blank, you can use:

=A1=""

If you have multiple conditions to check, you can use an AND or OR statement, i.e.

=OR(condition 1, A1="")

=AND(condition 1, A1="")