Conditional Formatting Formula

[STEVENS3010]

Hey guys,

I'm trying to add text to a cell based on another cell's value using conditional formatting. (i.e. when a certain numerical value is input in one cell, a text will display in another cell).

In this scenario I'm trying to make the text display if the numerical value is less than 5.

I've added the below formula but I'm not getting the text display in the cell where I've added the formatting. Any ideas???

=IF(F4<5,"Bottom 50%","")

 

[Fluff]

Hi & welcome to MrExcel.
As this is a totally different question, you need to start a thread of your own. Thanks