How do I set more then 3 Condition for a cell?

[Charlie Lam]

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?

 

[Arvin Meyer [MVP]]

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.

 

[Charlie Lam]

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.

 

[John W. Vinson]

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.