If a cell has a text value then next one must have a percentage.

[Gregwaa]

I am new to conditional formatting and have grasped the basics, I now need help on the following, When i state "Client" in A1 i need B1 to appear "15%", is this possible?

Thanks in advance

[Fotis1991]

Hi.

Welcome to the forum.

Yes. But this is not conditional Formatting!

In B1 put this formula.

Please Login or Register  to view this content.

Format as percentage.

[Gregwaa]

Thank you very much, as i thought it was a conditional format i was going to make a few rules, what do i do if i need "Client1" to be "15%" but "Client2" to be "21%" and so on?

[Fotis1991]

If you have few clients you can use multiple if..BUT the correct way is to create a table with all your clients and their percentages and then use INDEX&MATCH for getting your results.

As you said that you are new to this and perhaps you can not handle it take a look to a small example.

[Gregwaa]

Thanks, I will work using this index&match

[Fotis1991]

You are welcome and thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[Gregwaa]

Reputation added and will now Solve tread. Definitely will be back with other questions

[Fotis1991]

Will be waiting for your next time!