Insert text in cell based on conditional format?

[robertlf]

I'm new to Excel and use Mac Excel 2011. I understand the basics of conditional formatting but I can't quite figure out how to enter text in one cell based on whether another cell is greater than a third cell. Here's what I want to do:

if a1 <= b1 then insert text "BUY" in cell c1

If I could add color to that cell c1 to make it stand out when the condition is satisfied, that would be a bonus.

Thank you very much.

 

[JoeMo]

The formula in C1 would be:
=IF(A1<=B1,"BUY","")
The CF formula would be:
=$A1<=$B1
or the alternative
=$C1="BUY"

 

[robertlf]

This didn't work for me. If I entered the formula you specified and then replaced the "54.42" in C10 with "50.00", I didn't see "BUY" in cell Q10.

Imgur: The most awesome images on the Internet

 

[JoeMo]

This didn't work for me. If I entered the formula you specified and then replaced the "54.42" in C10 with "50.00", I didn't see "BUY" in cell Q10.

Imgur: The most awesome images on the Internet

You haven't used the correct formula. The first formula goes in the cell, the next one is for the CF.

 

[robertlf]

Ohhhhh. Now I understand. Thank you!