Conditional Format Issue

[Darkdrew]

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

 

[Ron Coderre]

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

 

[Bob Phillips]

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]

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

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

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