View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Highlight cells in a row with a given value

Hi,

Select ypu data then

Format|Conditional format
cell value is
Select 'less than'
enter 0 in the value box
Pick your colour
Click OK

Mike

"evoxfan" wrote:

I have a simple math formula (sum) in column adding values typed into
previous columns. I would like for any value less than 0 to be highlited in
yellow.

Any help is appreciated.

Thanks.