| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting and Blanks
I want to conditional format a range of cells. There are many in varied
places that are blank. However, when I apply CF to the cells using a less that .5, the cell is formatted. I really want that particular cell left alone. How do I tell Excel to leave the blanks alone? -- Thanks As Always Rip |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting and Blanks
Use formula is and
=AND(A1<"",A1<0.5) -- Regards, Peo Sjoblom "Ripper" wrote in message ... I want to conditional format a range of cells. There are many in varied places that are blank. However, when I apply CF to the cells using a less that .5, the cell is formatted. I really want that particular cell left alone. How do I tell Excel to leave the blanks alone? -- Thanks As Always Rip |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting and Blanks
Try this:
=AND(B1<5,B1<0) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ripper" wrote in message ... I want to conditional format a range of cells. There are many in varied places that are blank. However, when I apply CF to the cells using a less that .5, the cell is formatted. I really want that particular cell left alone. How do I tell Excel to leave the blanks alone? -- Thanks As Always Rip |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting and Blanks
Your eyes must be younger then mine!<g
I didn't see that decimal. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Peo Sjoblom" wrote in message ... Use formula is and =AND(A1<"",A1<0.5) -- Regards, Peo Sjoblom "Ripper" wrote in message ... I want to conditional format a range of cells. There are many in varied places that are blank. However, when I apply CF to the cells using a less that .5, the cell is formatted. I really want that particular cell left alone. How do I tell Excel to leave the blanks alone? -- Thanks As Always Rip |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Average Array with Dates, <blanks, 0 | Excel Worksheet Functions | |||
| Conditional Format Blanks | Excel Discussion (Misc queries) | |||
| Conditional Average Ignoring Blanks | Excel Worksheet Functions | |||
| Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) | |||
| Use Conditional Formats to highlight blanks? | Excel Worksheet Functions | |||
Linear Mode
