Excel 2008 : solved: Highlight cells based on other columns

[guyel]

I really did look for this before posting. It sounds simple but I can't figure it out. My spreadsheet in column B has many, many account numbers. I want to format cells in Column F based on the cell values in B.

For example: cells B1, B2, B3....have account numbers that are in numerical order. Column F has $ amounts that are held in each account. I want a formula that will highlight the dollar amount in Col F if Col B is within ( including the highest and lowest account) in a specific range ex. if column B is >=110031100004 and <=110031100600 then format green.

I am not sure how to do this using Excel 2008

Thank you very much for your help!!!