It has been a while since using sharepoint lists and I am a bit out of practice!

I have set up a list which shows a list of Assessments which each staff member needs to complete and the date it expires. Not everyone has to do the same assessments. 

I need to add to add conditional formatting into a date column to do the following:

If the cell is blank for it to be shaded grey.

If the date has expired the for it to be shaded red (the light coloured red)

If the date has not expired for it to be coloured green (the light green).

Any help much appreciated.

​It has been a while since using sharepoint lists and I am a bit out of practice! I have set up a list which shows a list of Assessments which each staff member needs to complete and the date it expires. Not everyone has to do the same assessments.  I need to add to add conditional formatting into a date column to do the following: If the cell is blank for it to be shaded grey.If the date has expired the for it to be shaded red (the light coloured red)If the date has not expired for it to be coloured green (the light green). Any help much appreciated.   Read More

​