Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Format Changes When Data Is Entered - Not Conditional Formatt | Excel Worksheet Functions | |||
Conditional format of minimum number | Excel Worksheet Functions | |||
Conditional format question | Excel Discussion (Misc queries) | |||
Conditional Format Question | Excel Worksheet Functions | |||
Copying a conditional format | Excel Worksheet Functions |