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]

Conditional formatting cannot "add" a value to a cell, it can only affect the way it's displayed.

You would need to put that formula in the cell.

 

[STEVENS3010]

Ah I understand, thanks for coming back to me so quickly. Can I adapt the formula to include more rules in that case? (e.g. if less than 5 display "Bottom 50%, if between 5 and 7 then display "51% to 66%" and so on???

 

[Fluff]

You can nest the If function like

=IF(F4<5,"Bottom 50%",IF(F4<7,"51% to 66%",""))

 

[STEVENS3010]

Thank you, that's a great help.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[STEVENS3010]

Me again, sorry. Separate to the above, I am trying to use the following formula to format a cell based on two values in two differing cells.

AND($B$9<=75%,$F$2="Value 1")

- is it possible to tweak this formula slightly, maybe using the 'OR' function to encompass differing values in cell F2 (in this example)

e.g. F2="value 1" or "value 2" or "value 3" - I'm not sure where the adjustment would need to be made.

Thanks for any help as always

 

[Joe4]

Is this what you are looking for?
AND($B$9<=75%,OR($F$2="Value 1",$F$2="Value 2",$F$2="Value 3"))

 

[Fluff]

Another option if this is going into a cell, rather than in CF

=AND($B$9<=75%,OR($F$2={"Value 1","Value 2","Value 3"}))

 

[STEVENS3010]

Thanks both - although unfortunately neither of the above appear to work?