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