Hi! Gord Dibben,
My problem not yet solved. Any idea?


"Narnimar" wrote:

Hi,
I succeded to install it. but this cf plus tool didn't work in my work book
same as the 3 conditional format work which i used to do regularly. The
condition is that I use date format like below in my calender

condition 1: if the cell value is between "(from date today)" and "(A
number of days)" then format pattern color should be yellow

condition 2 : if the cell value is between "(from date today + A number
of days)" and "(B number of days)" then format pattern color should be green

condition 3 : if the cell value is between "(from date today + A number
of days" + "B number of days)" and "(C number of days)" then format pattern
color should be pink

condition 4 : if the cell value is between "(from date today + A number
of days" + "B number of days + C number of days) and "( D number of days)"
then format pattern color should be brown

condition 5 : if the cell value is between "(from date today + A number
of days" + "B number of days + C number of days + D number of days)" and "(E
number of days)" then format pattern color should be red

...and so on....

This is not working. please guide me further.

Thank you,
- Narnimar





"Gord Dibben" wrote:

You downloaded and saved the *.ZIP file.

Find this file on your computer.

Move it to your Office\Library folder.

Double-click to open and hit FileExtract All.

Follow the wizard and extract to the Library folder.

Open Excel and a workbook.

Go to ToolsAdd-ins and place a checkmark next to CFPlus add-in.

Your Menu bar will get a new item......xld Tools.

Select to use.


Gord Dibben MS Excel MVP

On Fri, 15 Sep 2006 01:16:01 -0700, Narnimar
wrote:

Hi,
Thank you for your suggestion. I have dowloaded it and saved it. Can you
please tell me further what is the next step to apply and get 30 condition
option in my work sheet menu?
Thank you.
- Narnimar

"Gord Dibben" wrote:

Three conditions, 4 if you count default, is the limit in 2003.

Go to Bob Phillips' site and download the CFPlus add-in which allows up to 30
conditions.

http://www.xldynamic.com/source/xld.....Download.html



Gord Dibben MS Excel MVP



On Fri, 8 Sep 2006 05:59:02 -0700, Narnimar
wrote:

I am using excel 2003 version. I want to know whether is there a chance to
get more steps in conditional formatting? I want this option regularly for
color filling in a spreadseet for a date formatted area.