| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format
Sorry mate my mistake, Top class work. Thanks alot
"Mike H" wrote: The CF I just posted will highlight a day that is 30 days or less in the future and the cell will remain highlighted after that even if the date goes in the past. Mike "Sibbs" wrote: Sorry Mike, maybe I am confusing the issue. What I would like is for it to tell me 30 days in advance that the cousre will expire and then if it does expire past the 30 days remain highlighted. Sorry to be a pest "Mike H" wrote: use this one instead =B1-TODAY()<=30 Mike "Sibbs" wrote: Worked a treat but for one thing. The dates that have already gone pst the 30 days dont stay highlighted. i.e if the course has already expired. "Mike H" wrote: Hi, If I've understood correctly yo have an expiry date in column b that you want to turn (say) red a month before that date. Select your dates and this assumes they begin in B1 and then:- Format|conditional format. Select formula is and paste this in and pick a colour =AND(B1-TODAY()=0,B1-TODAY()<=30) Mike "Sibbs" wrote: Hi Guys, if someone could help I would be most grateful. My problem is: I have a sheet of course names in columns C to V. Names of personnel down the left in column A with cels 6&7 merged, 8&9 merged, an so on. (Only column A has been merged in this way) Each course has under it a completed and expires date. ie column c, completed c6 and expires c7. Column B just has COM and EXP below it beside each name to identify the dates The date format is dd/mm/yy What I would like is for the the expirey date to flag up a month in advance with say the colour red. Does that make any sense to anyone? I hope so. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format (not color format) | Excel Discussion (Misc queries) | |||
| How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
| Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
| copy conditional format to regular format | Setting up and Configuration of Excel | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Hybrid Mode
