If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I set more then 3 Condition for a cell?
I have cells that I want to change color automatically when I input a certain
value, Letter or Number, However the conditional format only allows me to do 3 conditions/colors. Is there a way I can add more then 3 conditions? |
#2
|
|||
|
|||
How do I set more then 3 Condition for a cell?
The newest version of Access (2007) allows 7 (or maybe more, but I think
it's 7) conditions. If you are using a single form view, you can write code for as many conditions as you please. If you need help with the code, post back. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Charlie Lam" Charlie wrote in message ... I have cells that I want to change color automatically when I input a certain value, Letter or Number, However the conditional format only allows me to do 3 conditions/colors. Is there a way I can add more then 3 conditions? |
#3
|
|||
|
|||
How do I set more then 3 Condition for a cell?
Thank you for the help. I am sorry I didn't specify, I am looking to do this
in Excel, since I am more familiar with Excel. "Arvin Meyer [MVP]" wrote: The newest version of Access (2007) allows 7 (or maybe more, but I think it's 7) conditions. If you are using a single form view, you can write code for as many conditions as you please. If you need help with the code, post back. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Charlie Lam" Charlie wrote in message ... I have cells that I want to change color automatically when I input a certain value, Letter or Number, However the conditional format only allows me to do 3 conditions/colors. Is there a way I can add more then 3 conditions? |
#4
|
|||
|
|||
How do I set more then 3 Condition for a cell?
On Mon, 13 Jul 2009 13:15:01 -0700, Charlie Lam
wrote: Thank you for the help. I am sorry I didn't specify, I am looking to do this in Excel, since I am more familiar with Excel. In that case I'd suggest you post in an Excel newsgroup rather than this one, which is for Access. The webpage can be confusing and may have misled you - scroll down the list of subject areas and find an appropriate Excel group, and the good folks over there will be able to help. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|