How do I get 6 conditional formats?
 

Hi

I am trying to create a programme in excel based on latest and actual
dates. Using conditional formatting, I have been able to shade the
cell that references the latest an activity can be done. But I also
want to add the same colour to the actual date (viewed as a upside down
triangle) but cannot add any more conditions Format Conditional
Formatting

What I have at the moment is

=IF(OR($W9=AG$4,$AA9=AG$4,$AC9=AG$4),"▼",IF(OR($V9 ="n/a",$Y9="n/a",$AB9=""),"",IF($V9=AG$4,1,IF($Y9=AG$4,2,IF($AB9 =AG$4,3,IF(OR($V9AG$4,$AB9AG$4),"▬",""))))))


I want to be able to say IF(OR($W9=AG$4,"▼", and also make it 4
(and conditional format so that I can make it the same colour as the
latest cell shade). In all I will have 6 conditional formats

Do I make any sense? I am not good explaining what I am trying to
do...


Any help will be appreciated.

Thanks
KatieJane


--
KatieJane
------------------------------------------------------------------------
KatieJane's Profile: http://www.excelforum.com/member.php...o&userid=37334
View this thread: http://www.excelforum.com/showthread...hreadid=570303

How do I get 6 conditional formats?
 

You can give this a try...

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

--
HTH...

Jim Thomlinson


"KatieJane" wrote:


Hi

I am trying to create a programme in excel based on latest and actual
dates. Using conditional formatting, I have been able to shade the
cell that references the latest an activity can be done. But I also
want to add the same colour to the actual date (viewed as a upside down
triangle) but cannot add any more conditions Format Conditional
Formatting

What I have at the moment is

=IF(OR($W9=AG$4,$AA9=AG$4,$AC9=AG$4),"–¼",IF(OR($ V9="n/a",$Y9="n/a",$AB9=""),"",IF($V9=AG$4,1,IF($Y9=AG$4,2,IF($AB9 =AG$4,3,IF(OR($V9AG$4,$AB9AG$4),"–¬",""))))))


I want to be able to say IF(OR($W9=AG$4,"–¼", and also make it 4
(and conditional format so that I can make it the same colour as the
latest cell shade). In all I will have 6 conditional formats

Do I make any sense? I am not good explaining what I am trying to
do...


Any help will be appreciated.

Thanks
KatieJane


--
KatieJane
------------------------------------------------------------------------
KatieJane's Profile: http://www.excelforum.com/member.php...o&userid=37334
View this thread: http://www.excelforum.com/showthread...hreadid=570303

How do I get 6 conditional formats?
 

I don't want to use a download - other people need to use this
spreadsheet.

Would you be able to point me in the direction of setting it up using
VBA.

Thanks


--
KatieJane
------------------------------------------------------------------------
KatieJane's Profile: http://www.excelforum.com/member.php...o&userid=37334
View this thread: http://www.excelforum.com/showthread...hreadid=570303

How do I get 6 conditional formats?
 

The download actually adds code to the sheets it is being used in. Give it a
try. If it is not what you want then you will have to get into the VBA and it
is a fairly involved process as only 3 true conditional formats are supported.
--
HTH...

Jim Thomlinson


"KatieJane" wrote:


I don't want to use a download - other people need to use this
spreadsheet.

Would you be able to point me in the direction of setting it up using
VBA.

Thanks


--
KatieJane
------------------------------------------------------------------------
KatieJane's Profile: http://www.excelforum.com/member.php...o&userid=37334
View this thread: http://www.excelforum.com/showthread...hreadid=570303

How do I get 6 conditional formats?
 

Thanks Jim - I will test it out.


--
KatieJane
------------------------------------------------------------------------
KatieJane's Profile: http://www.excelforum.com/member.php...o&userid=37334
View this thread: http://www.excelforum.com/showthread...hreadid=570303

How do I get 6 conditional formats?
 

I tested the add-in that you suggested and it didn't work.

When I used the CF+ tool it kept on changing the condition. I wante
it to be the Cell value equals 1 and it kept on changing it to Th
formula of the cell is E9=1

How hard would it be to do the conditional formatting in VBA?

Thanks
kat

--
KatieJan
-----------------------------------------------------------------------
KatieJane's Profile: http://www.excelforum.com/member.php...fo&userid=3733
View this thread: http://www.excelforum.com/showthread.php?threadid=57030