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
I have an excel file containing values from the Square of Nine and would like to add conditional formatting to include:
1. horizontal line at 180 degree angle
2. Vertical line at 90 degree angle
3. diagonal line at 45 degree angle
Can you help formulate a formula that can be enabled as a...