View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default newbie needs help...

You will have to do a lot of scrolling.

Select all 3000 cells, use FormatConditional Formatting
Change Condition1 to Formuls Is
Add a formula of =A1<108
On pattern tab select a colour
Exit out

--

HTH

RP

"Dave" wrote in message
...


Coloured in the list itself would be fine.

Thanks,
Dave

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!