Conditional Format Issue
 

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

Conditional Format Issue
 

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.

Conditional Format Issue
 

Use CF with Condition 1 of Formula Is and a formula of

=AND(A1<"",A1<3,A1<5)

then form at to your hearts content.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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

Conditional Format Issue
 

That seems to work. I just had to change A1 to RC. I prefer the R1C1
format. Thanks for the help.

"Ron Coderre" wrote:

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.