| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting
Hello
In A1, I have the text "Dates" and in B2:30, I will have a date per cell. Can I use conditional formatting for Excel to colour B2 when the date entered is 1 week or 1 month old. Example: I have entered in B2 the date 14/08/06, how can conditional formatting kicks in by colouring the cell red automatically one week later on 21/08/06. Many thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting
Hi,
Choose "lesser then" and type this formula " =today()-7 " for a week One week later the cell should turn red or whatever the colour you choose. Petter Pascale skrev: Hello In A1, I have the text "Dates" and in B2:30, I will have a date per cell. Can I use conditional formatting for Excel to colour B2 when the date entered is 1 week or 1 month old. Example: I have entered in B2 the date 14/08/06, how can conditional formatting kicks in by colouring the cell red automatically one week later on 21/08/06. Many thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting
Hello Pascale,
Something along these lines ... Choose Formula Is and add following formula : =(TODAY()-B2)=7 HTH Cheers Carim |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting
Hello
Excellent. THANK YOU. It works!! so if I need for 2 months, what would I type =today()-60 ??? Pascale "Fingerjob" wrote: Hi, Choose "lesser then" and type this formula " =today()-7 " for a week One week later the cell should turn red or whatever the colour you choose. Petter Pascale skrev: Hello In A1, I have the text "Dates" and in B2:30, I will have a date per cell. Can I use conditional formatting for Excel to colour B2 when the date entered is 1 week or 1 month old. Example: I have entered in B2 the date 14/08/06, how can conditional formatting kicks in by colouring the cell red automatically one week later on 21/08/06. Many thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting
Hello Carim
THANK YOU VERY MUCH. It works!!! So what would I put if it were for 2 months =(TODAY()-B2)=60 ??? "Carim" wrote: Hello Pascale, Something along these lines ... Choose Formula Is and add following formula : =(TODAY()-B2)=7 HTH Cheers Carim |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting
Sorry to trouble you AGAIN but when I copied this formula to some empty
cells, they all turn red. any suggestion to avoid this?? Many thanks Pascale "Fingerjob" wrote: Hi, Choose "lesser then" and type this formula " =today()-7 " for a week One week later the cell should turn red or whatever the colour you choose. Petter Pascale skrev: Hello In A1, I have the text "Dates" and in B2:30, I will have a date per cell. Can I use conditional formatting for Excel to colour B2 when the date entered is 1 week or 1 month old. Example: I have entered in B2 the date 14/08/06, how can conditional formatting kicks in by colouring the cell red automatically one week later on 21/08/06. Many thanks |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting
Hello Pascale,
I am surprised ... copying "conditionnally formatted" and clearing cells contents should not format the empty cell, since the condition is not met ... If you still have this problem, could you explain a bit further ... A + Carim |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting
I know this post is over a year old but I found it tremendously helpful in
formatting a project coming up due and then when it was overdue. Thanks! "Carim" wrote: Hello Pascale, Something along these lines ... Choose Formula Is and add following formula : =(TODAY()-B2)=7 HTH Cheers Carim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting a range with conditional formatting | Excel Worksheet Functions | |||
| conditional formatting glitches | Excel Discussion (Misc queries) | |||
| Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
| conditional formatting | Excel Discussion (Misc queries) | |||
| cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
Linear Mode
