Changing format of cell based on text in another cell

[coolguyhb]

I'm trying to change the cell format based on another cells text.

example:

F6 contains the words "Contract Rate:". i need H6 to be formatted to "0%" only when the words "Contract Rate:" is showing in F6. F6 is variable and changes based on a drop down selection. H6 is being used for multiple input types, could be text or in this case will be a percentage number. This is why I'm trying to conditional format H6.

 

[AliGW]

You can't use a CF rule to place text inside a cell.

 

[Tetra201]

Just use a set of CF rules of the type

=F6="Contract Rate:"

and assign the desired number format to each rule.

 

[coolguyhb]

Just use a set of CF rules of the type

=F6="Contract Rate:"

and assign the desired number format to each rule.

Thats the first thing i tried. But it didn't seem to work. I kinda over thought this. lol. I ended up just formatting the cell H6 to percentage after realizing that the only time someone would be using this field for a numerical input would be for the contract rate all other input in this cell will be text unless Contract Rate is selected from a dropdown menu.

Thanks for your help. I'm sure i will have other questions for this forum in the future. Very happy to be a subscriber.