|
|
| How do I get 6 conditional formats? |
|
| Author |
Message |
ejcornwell
|
 Posted: Thu Aug 10 08:56:02 CDT 2006 |
Top |
Excel Programming >> 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($V9>AG$4,$AB9>AG$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.hide-link.com/ ;userid=37334
View this thread: http://www.hide-link.com/
Excel80
|
| |
|
| |
|
James_Thomlinson
|
| Posted: Thu Aug 10 08:56:02 CDT 2006 |
Top |
Excel Programming >> How do I get 6 conditional formats?
You can give this a try...
http://www.xldynamic.com/source/xld.CFPlus.Download.html
--
HTH...
Jim Thomlinson
>
> 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($V9>AG$4,$AB9>AG$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?action=getinfo&userid=37334
> View this thread: http://www.excelforum.com/showthread.php?threadid=570303
>
>
|
| |
|
| |
|
KatieJane
|
| Posted: Thu Aug 10 09:34:18 CDT 2006 |
Top |
|
| |
|
James_Thomlinson
|
| Posted: Thu Aug 10 12:04:02 CDT 2006 |
Top |
Excel Programming >> 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
>
> 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?action=getinfo&userid=37334
> View this thread: http://www.excelforum.com/showthread.php?threadid=570303
>
>
|
| |
|
| |
|
KatieJane
|
| Posted: Fri Aug 11 06:03:37 CDT 2006 |
Top |
|
| |
|
KatieJane
|
| Posted: Fri Aug 11 09:52:10 CDT 2006 |
Top |
Excel Programming >> 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?action=getinfo&userid=3733
View this thread: http://www.excelforum.com/showthread.php?threadid=57030
|
| |
|
| |
|
| |
|