Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
increase conditional formating options
How do I increase the No. of formats in conditional formating from 3 to 6
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
increase conditional formating options
Hi!
Take a look at these: http://mcgimpsey.com/excel/conditional6.html http://www.xldynamic.com/source/xld.....Download.html Biff "Eqa" wrote in message ... How do I increase the No. of formats in conditional formating from 3 to 6 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
increase conditional formating options
It cant be done other than using VB code. Search 'Excel Programming on
Google, there are loads of posts on this subject in there, Regards, Alan. "Eqa" wrote in message ... How do I increase the No. of formats in conditional formating from 3 to 6 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
increase conditional formating options
This doesn't seem to help me using dates only numbers. How do i apply this to
a variety of old dates ? EG over 30 days old over 60 days old etc from today? "Biff" wrote: Hi! Take a look at these: http://mcgimpsey.com/excel/conditional6.html http://www.xldynamic.com/source/xld.....Download.html Biff "Eqa" wrote in message ... How do I increase the No. of formats in conditional formating from 3 to 6 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
increase conditional formating options
Hi!
Dates *ARE* numbers! (unless you specifically enter a date TEXT string) They're just numbers formatted to look like dates. The technique from that first link won't work for your situtation. That add-in from the second link should work (although I've never tried it. The authors are highly regarded and reputable.) Other than those 2 choices your only remaining option is VBA code. I can't help with that. Biff "Eqa" wrote in message ... This doesn't seem to help me using dates only numbers. How do i apply this to a variety of old dates ? EG over 30 days old over 60 days old etc from today? "Biff" wrote: Hi! Take a look at these: http://mcgimpsey.com/excel/conditional6.html http://www.xldynamic.com/source/xld.....Download.html Biff "Eqa" wrote in message ... How do I increase the No. of formats in conditional formating from 3 to 6 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
increase conditional formating options
Biff
What number do I use for Today as it must change everyday? Do I have to reformat the cell every day?? I do not understand how to get the info from your second link either. Sorry for sounding like a dill. "Biff" wrote: Hi! Dates *ARE* numbers! (unless you specifically enter a date TEXT string) They're just numbers formatted to look like dates. The technique from that first link won't work for your situtation. That add-in from the second link should work (although I've never tried it. The authors are highly regarded and reputable.) Other than those 2 choices your only remaining option is VBA code. I can't help with that. Biff "Eqa" wrote in message ... This doesn't seem to help me using dates only numbers. How do i apply this to a variety of old dates ? EG over 30 days old over 60 days old etc from today? "Biff" wrote: Hi! Take a look at these: http://mcgimpsey.com/excel/conditional6.html http://www.xldynamic.com/source/xld.....Download.html Biff "Eqa" wrote in message ... How do I increase the No. of formats in conditional formating from 3 to 6 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
increase conditional formating options
Hi!
What number do I use for Today as it must change everyday? You would use the TODAY() function. Do I have to reformat the cell every day?? No, The TODAY() function is a volatile function meaning that it updates every time the file calculates. You should post this in the programming forum and include all the conditions in your post. The more info you provide the easier it will be for someone to come up with a good solution. Biff "Eqa" wrote in message ... Biff What number do I use for Today as it must change everyday? Do I have to reformat the cell every day?? I do not understand how to get the info from your second link either. Sorry for sounding like a dill. "Biff" wrote: Hi! Dates *ARE* numbers! (unless you specifically enter a date TEXT string) They're just numbers formatted to look like dates. The technique from that first link won't work for your situtation. That add-in from the second link should work (although I've never tried it. The authors are highly regarded and reputable.) Other than those 2 choices your only remaining option is VBA code. I can't help with that. Biff "Eqa" wrote in message ... This doesn't seem to help me using dates only numbers. How do i apply this to a variety of old dates ? EG over 30 days old over 60 days old etc from today? "Biff" wrote: Hi! Take a look at these: http://mcgimpsey.com/excel/conditional6.html http://www.xldynamic.com/source/xld.....Download.html Biff "Eqa" wrote in message ... How do I increase the No. of formats in conditional formating from 3 to 6 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
increase conditional formating options
Biff,
I have tried using TODAY() but it doesn't seem to accept it. However if I enter a number it works fine? "Biff" wrote: Hi! What number do I use for Today as it must change everyday? You would use the TODAY() function. Do I have to reformat the cell every day?? No, The TODAY() function is a volatile function meaning that it updates every time the file calculates. You should post this in the programming forum and include all the conditions in your post. The more info you provide the easier it will be for someone to come up with a good solution. Biff "Eqa" wrote in message ... Biff What number do I use for Today as it must change everyday? Do I have to reformat the cell every day?? I do not understand how to get the info from your second link either. Sorry for sounding like a dill. "Biff" wrote: Hi! Dates *ARE* numbers! (unless you specifically enter a date TEXT string) They're just numbers formatted to look like dates. The technique from that first link won't work for your situtation. That add-in from the second link should work (although I've never tried it. The authors are highly regarded and reputable.) Other than those 2 choices your only remaining option is VBA code. I can't help with that. Biff "Eqa" wrote in message ... This doesn't seem to help me using dates only numbers. How do i apply this to a variety of old dates ? EG over 30 days old over 60 days old etc from today? "Biff" wrote: Hi! Take a look at these: http://mcgimpsey.com/excel/conditional6.html http://www.xldynamic.com/source/xld.....Download.html Biff "Eqa" wrote in message ... How do I increase the No. of formats in conditional formating from 3 to 6 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
increase conditional formating options
Hi!
See your post in programming. Biff "Eqa" wrote in message ... Biff, I have tried using TODAY() but it doesn't seem to accept it. However if I enter a number it works fine? "Biff" wrote: Hi! What number do I use for Today as it must change everyday? You would use the TODAY() function. Do I have to reformat the cell every day?? No, The TODAY() function is a volatile function meaning that it updates every time the file calculates. You should post this in the programming forum and include all the conditions in your post. The more info you provide the easier it will be for someone to come up with a good solution. Biff "Eqa" wrote in message ... Biff What number do I use for Today as it must change everyday? Do I have to reformat the cell every day?? I do not understand how to get the info from your second link either. Sorry for sounding like a dill. "Biff" wrote: Hi! Dates *ARE* numbers! (unless you specifically enter a date TEXT string) They're just numbers formatted to look like dates. The technique from that first link won't work for your situtation. That add-in from the second link should work (although I've never tried it. The authors are highly regarded and reputable.) Other than those 2 choices your only remaining option is VBA code. I can't help with that. Biff "Eqa" wrote in message ... This doesn't seem to help me using dates only numbers. How do i apply this to a variety of old dates ? EG over 30 days old over 60 days old etc from today? "Biff" wrote: Hi! Take a look at these: http://mcgimpsey.com/excel/conditional6.html http://www.xldynamic.com/source/xld.....Download.html Biff "Eqa" wrote in message ... How do I increase the No. of formats in conditional formating from 3 to 6 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
can i freeze conditional formating to copy to another worksheet | Excel Discussion (Misc queries) | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) |