conditional formating greater than

F

fearthespear

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

T. Valko

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 Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=F2>B2
Click the Format button
Select the desired style(s)
OK out
 
Top