| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.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($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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.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 "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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.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...fo&userid=3733 View this thread: http://www.excelforum.com/showthread.php?threadid=57030 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formats, how to scroll and view all formats? | Excel Worksheet Functions | |||
| Conditional Formats with ABS | Excel Worksheet Functions | |||
| Conditional formats- paste special formats? | Excel Discussion (Misc queries) | |||
| paste conditional formats as formats | Excel Discussion (Misc queries) | |||
| More than three conditional formats | Excel Programming | |||
Linear Mode
