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: 3
Default past date cell colour change

Hi
I want to use excel to keep training records
what I need is names along the top then a list down the left of details of
training also a row showing renewal after ?? months
so I can enter the date they completed training in the box under there name

ok so far

but how can I get this cell to turn red and display needs training once the
date trained goes past the renewal time i.e. 12 months

any help or pointing in the right direction would be great

Thanks

 
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
change a cell background colour to my own RGB colour requirements Stephen Doughty Excel Discussion (Misc queries) 4 June 16th 06 01:08 PM
Change cell colour by date Dri New Users to Excel 5 February 8th 06 10:29 PM
How can i change cell colour depending on month of date in cell? andy75 Excel Discussion (Misc queries) 2 January 6th 06 07:46 AM
How to change cell colour, X no days from inserted date in Excel? Bayvon Excel Worksheet Functions 0 October 14th 05 05:17 AM
Past date in column to change color Chris Excel Worksheet Functions 2 June 17th 05 12:20 AM


All times are GMT +1. The time now is 10:19 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"