View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default conditional format a series of numbers

Just use CF, select all the cells, then set a condition of greater than, a
value of 50, then click Format to set as required.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"TJ" wrote in message
...
Hi,
I like to do this without using the conditonal format.
I have a column of figures I like to bold & make yellow if they are over

50
Any help would be appreicated

thanks in advance
TJ