Excel 2008 : solved: Highlight cells based on other columns

**guyel** · 07-16-2010, 03:55 PM

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!!!

**martindwilson** · 07-17-2010, 08:09 PM

=and(b1>=110031100004 ,b1<=110031100600)

**guyel** · 07-19-2010, 08:37 AM

Thank you, but this only highlights cells in B. How do I highlight cells in F based on the values in B? (I chose column F to conditional format and entered this formula)

Thank you