Using IF statement to flag a required action

		Microsoft Office Forums > Microsoft Excel > Excel
Using IF statement to flag a required action

FAQ

Thread Tools

Display Modes

01-27-2015, 12:54 PM

Pecoflyer

Windows 7 64bit Using IF statement to flag a required action

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Perhaps

Code:

=IF(E7-30<=TODAY(),"refresher due","")

?
Use CF to colour the text like =F7<>"" format red

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:02 PM.