conditional formating greater than
 

i have two columns, one is sales price and one is asking price. i need to
highlight all the sales prices that are greater than there corresponding
asking price. i am stumped.
sales price=column F
asking price=column B
how do i do this?

conditional formating greater than
 

Try this...

Assuming there are no empty cells in the Asking price column

Assume the range of interest is F2:F10
Select the range F2:F10
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=F2B2
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"fearthespear" wrote in message
...
i have two columns, one is sales price and one is asking price. i need to
highlight all the sales prices that are greater than there corresponding
asking price. i am stumped.
sales price=column F
asking price=column B
how do i do this?