Excel conditional formatting

  Bee Jay S 21:08 27 Sep 2006
Locked

I have a sheet which has records date of training, both ones that have been completed and ones booked for future dates. What I would like to do is have the cells with future dates in formatted in a different colour eg red. What formula do i need to do this?

  VoG II 21:11 27 Sep 2006

=A1>TODAY()

  Bee Jay S 21:33 27 Sep 2006

Thanks VoG for a very quick response as usual.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Lightwell software lets you create mobile apps without using code

Best value Mac: Which is the best £1249 Mac to buy

Comment désactiver les programmes qui s'exécutent au démarrage de Windows 10 ?