Using IF statement to flag a required action

stuwoolf · #3 01-27-2015, 02:10 PM

Quote:

Originally Posted by Pecoflyer

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
flag identical words?	21rouge	Word	1	09-21-2013 08:42 AM
Follow-up Flag Behavior	curtis.walker@sgmc.org	Outlook	1	03-06-2013 08:52 AM
Task closing when flag is cleared	pro3carp3	Outlook	1	12-05-2011 10:21 PM
What IF statement required	dr4ke	Excel	8	09-01-2011 07:41 AM
How to link an action on one slide on a powerpoint with the same action on another	slevinmj	PowerPoint	0	02-24-2011 05:38 AM