My boss has seen a word cloud and now wants me to create one (in Excel 2003).
Problem, I can't use Wordle for security reasons. Partial solution - I have used the (mighty!) Chandoo's solution to create a cell populated with words with font size based on frequency of use. However Chandoo's solution is one colour only, ie whatever the cell font colour is.
Is there a way, perhaps using Conditional Formatting, to select words from the table and use this data as the basis for the formula within a Conditional Format? eg if the table / cloud contains 'Cat, Dog, Mouse, Smith, Munroe, Adams, Cheese, Bread, Apple' is it possible to colour (for example) 'Cat' , 'Dog' and 'Mouse' in blue, 'Smith', 'Munroe', 'Adams' in red , 'Cheese', 'Bread', 'Apple' in green?
Alternatively a user could select the parameters based on the value against any other specified criteria eg Cat, Adams and Bread score below 20 = green, Dog and Cheese between 21 and 40 = blue, Mouse, Smith, Munroe and Apple over 41 = red.
Any thoughts gratefully received!
HughT
Problem, I can't use Wordle for security reasons. Partial solution - I have used the (mighty!) Chandoo's solution to create a cell populated with words with font size based on frequency of use. However Chandoo's solution is one colour only, ie whatever the cell font colour is.
Is there a way, perhaps using Conditional Formatting, to select words from the table and use this data as the basis for the formula within a Conditional Format? eg if the table / cloud contains 'Cat, Dog, Mouse, Smith, Munroe, Adams, Cheese, Bread, Apple' is it possible to colour (for example) 'Cat' , 'Dog' and 'Mouse' in blue, 'Smith', 'Munroe', 'Adams' in red , 'Cheese', 'Bread', 'Apple' in green?
Alternatively a user could select the parameters based on the value against any other specified criteria eg Cat, Adams and Bread score below 20 = green, Dog and Cheese between 21 and 40 = blue, Mouse, Smith, Munroe and Apple over 41 = red.
Any thoughts gratefully received!
HughT