Jan 06 2021 08:55 AM
I am wanting to show a an 'up arrow' or 'down arrow' into a cell depending if one number is higher or lower than another two adjacent cells
Jan 06 2021 09:02 AM
Hi @Bob_Lac
You would use the conditional format
Home tab --> click on Conditional format on the style group
Jan 06 2021 10:14 AM
Solution
You would you simple if formula if it is just adding arrow,
I assume that your data in cells B6, D6, so you can copy the arrow symbols and use them in the formula
=IF(B6>D6,"▼","▲")
Jan 06 2021 01:39 PM
Jan 06 2021 10:14 AM
Solution
You would you simple if formula if it is just adding arrow,
I assume that your data in cells B6, D6, so you can copy the arrow symbols and use them in the formula
=IF(B6>D6,"▼","▲")