View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Conditional formatting excluding empty cells

Assuming that comma in front of your first item was supposed to be a dot,
and trying to read into your example data coupled with your text write up
the best I can, are you looking to highlight all the numerical values in
your column and leave everything else alone? If so, try this Conditional
Format formula...

=ISNUMBER(A1)

--
Rick (MVP - Excel)


"Kicker" wrote in message
...
I have a collumn that shows project status with possible values of:

Started
,25
.50
.75
Complete
Stalled
Not Started

What I am trying to do is to get any cell where the value is NOT
"Complete",
"Not Started", "Stalled" or blank to have a different background color.
The
rest of the cells are default color.

I'd be happy to get anything that is not "Complete" and blank left as
default and the rest as colored. When I try to do this using conditional
formatting it always ends up with the blank cells shaded along with the
ones
I do want shaded.

Thanks

"T. Valko" wrote:

Need more info.

What cells do you want to format and based on what condition?

--
Biff
Microsoft Excel MVP


"Kicker" wrote in message
...
This may be a somple question for all of you. I want to use
conditional
formatting to change fill color that specifically excludes blank cells.

The question is: What value to I put in the condition/formula field of
the
dialog box for a blank/empty cell.