Thread: [Solved] Using IF statement to flag a required action
View Single Post
 
Old 01-27-2015, 02:10 PM
stuwoolf stuwoolf is offline Windows 8 Office 2010 64bit
Novice
  
Join Date: Dec 2014
Posts: 14
stuwoolf is on a distinguished road
Default
Quote:
Originally Posted by Pecoflyer View Post
Perhaps
Code:
=IF(E7-30<=TODAY(),"refresher due","")
?
Use CF to colour the text like =F7<>"" format red
Thank you for the prompt response.

It looks like your suggestion will work.

I'm not sure how to use the CF part of your response. Grateful of you could show where the =F7<>"" would be placed using the code you supplied?

Also, is it possible to shade the cell in yellow as well as red text?

Again, if so I will be grateful for a demonstration.

Thanks. I'm very pleased.
Reply With Quote