| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
I have a sheet that has conditional formatting that anything after a todays
date is red. What I really need is for that date that it looks at to never change. For Example: If today I run it and it uses 9-25-06 and then tomorrow I run it again the date is then 9-26-06 that it uses. How can I use a set date? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
You can just hard code the date in your formula... =DATE(2006,9,25)
-- Regards, Dave "Peco Worker" wrote: I have a sheet that has conditional formatting that anything after a todays date is red. What I really need is for that date that it looks at to never change. For Example: If today I run it and it uses 9-25-06 and then tomorrow I run it again the date is then 9-26-06 that it uses. How can I use a set date? |
| 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
