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

  • Thread starter Thread starter Charlie Lam
  • Start date Start date
C

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?
 
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.
 
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.
 
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.
Click to expand...

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.
 
Back
Top