Try this:

Assuming you want conditional fomatting on Cells A1:A10

Select A1:A10, with A1 as the active cell

<Format<Conditional Formatting
Formula Is: =AND(A1<"",AND(A1<3,A1<5))
Click the [Format] button and set your format
Click the [OK] buttons

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Darkdrew" wrote:

I need to format a column where everything that does not equal "3" or "5" is
highlighted and to ignore blank cells.