I have a spreadsheet where I want to change the colour and size of the text in a column depending upon the values of in adjacent columns.


ie. column a a1:a30 has a list of of 30 random words, one in each cell.
column b - B1:B30 contains a value of either 1, 2 or 3.
column c - C1:C30 contains a value of 1,2,3 or 4

I would like the words to in column A to change according to the value in column B & C.
The words must be displayed as green in color if value in adjacent cell in column b = 1, amber if adjacent cell in column b = 2 and red if the value in adjacent cell in column b = 3.
This I can achieve with three conditional formats so not a problem.
The next is a challange as one cannot change the cells font size conditionally. I would want the words in column to change font size depending upon the vakue of the cells in column c.
i.e font size 36 if the value is column c= 4, font size 28 if the value in column c =3 etc, font size 20 if = 2 and font size 12 if the value is 1.

If I am not explaining it to well here is a small sample.
A B C
Word1 1 1
Word2 2 2
Word3 3 3
Word4 1 4

I'm afraid you'll need VBA for this one

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post