Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 20th 05, 01:34 AM posted to microsoft.public.excel.worksheet.functions
Eqa
 
Posts: n/a
Default increase conditional formating options

How do I increase the No. of formats in conditional formating from 3 to 6

  #2   Report Post  
Old November 20th 05, 01:53 AM posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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   Report Post  
Old November 20th 05, 01:56 AM posted to microsoft.public.excel.worksheet.functions
Alan
 
Posts: n/a
Default 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   Report Post  
Old November 20th 05, 03:43 AM posted to microsoft.public.excel.worksheet.functions
Eqa
 
Posts: n/a
Default 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   Report Post  
Old November 20th 05, 04:02 AM posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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   Report Post  
Old November 20th 05, 05:20 AM posted to microsoft.public.excel.worksheet.functions
Eqa
 
Posts: n/a
Default 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   Report Post  
Old November 20th 05, 05:44 AM posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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   Report Post  
Old November 20th 05, 06:18 AM posted to microsoft.public.excel.worksheet.functions
Eqa
 
Posts: n/a
Default 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   Report Post  
Old November 20th 05, 06:42 AM posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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
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
Install dates formating using conditional formating? Jerry Eggleston Excel Discussion (Misc queries) 2 November 9th 05 06:49 PM
Conditional formating using formulas arifnj Excel Worksheet Functions 4 October 27th 05 01:56 PM
can i freeze conditional formating to copy to another worksheet Chris Lane Excel Discussion (Misc queries) 1 October 12th 05 06:53 PM
VLOOKUP & Conditional Formating Help. Excel'ed Failures Excel Discussion (Misc queries) 6 August 16th 05 04:46 PM
more than 3 conditional formating in excel Manan Excel Discussion (Misc queries) 2 February 7th 05 10:12 PM


All times are GMT +1. The time now is 02:06 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017