Conditional Formating for EXCEL 2003

[00Able]

I built a worksheet with conditional formating in excel 2010, however, end users are using 2003, and you can not use the amount of conditional formating in earlier versions.

[jeffreybrown]

As long as you do not go over 3 formats you are okay when using in 2003. If you want more than 3 you have to use some VBA.

For your problem...

=A1>3 >> select format

=AND(A1>0,A1<3) >> select format

http://www.contextures.com/xlcondFormat01.html

[DonkeyOte]

Techncially

Rule1:
=A1>3

Rule2:
=A1>0

should suffice though it might make sense to encase A1 within a SUM / N call to negate Text (or even an ISNUMBER test if Booleans are possible)