LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 148
Default Conditional Formatting or IF function

Hi,

I have a worksheet that on Col A I need a "tickler" to prompt me to update a
particular row based on date requirement on column B (i.e., every 30, 60 or
90, etc days).

I came up with a conditional formating on Col A, row 2:
=datevalue("2/25/2008"), will make a yellow background/pattern

Right now, I have to adjust the dates every 30, 60, days to promt me to
update.

An if function will also do: (please edit the formula below)

=IF(NOW()=DATEVALUE("1/3/2008"), " Update!","****")

If there a way to edit my conditional formatting or if formual to make it
prompt every 30, 60, etc. days.

Thank you in advance.

Danny





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting with IF function Michael Excel Discussion (Misc queries) 1 May 29th 07 05:38 AM
Conditional formatting with IF function Michael Excel Discussion (Misc queries) 2 May 28th 07 05:26 PM
Conditional Formatting with IF function mpenkala Excel Worksheet Functions 0 November 30th 06 04:02 PM
Help on a function with Conditional Formatting nemadrias Excel Worksheet Functions 1 August 10th 06 08:55 PM
Conditional Formatting (IF function) Neo1 Excel Worksheet Functions 5 March 2nd 06 10:38 PM


All times are GMT +1. The time now is 11:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"