I need help writing VBA code (and guidance on where I should put it) that will enable me to change the format of text within a cell when the value of that cell changes. This code will need to look at each cell within a range and make the appropriate chance to EACH cell.
Note that this value will not be changed by the user. It is a formula based cell and is therefore contingent on the values in other cells to affect it.
I can't use conditional formatting because i have more than 3 criteria.
Here is a basic description of my need:
If any cell within a specified range has the value "A", it should be Bold, Red (255,0,0), and size 13 font.
If any cell within the same range has a value of "B", it should be red (i don't know the RGB code), and size 10 font.
If any cell within the same range has a value of "C", the text should be green and size 10 font.
If any cell within the same range has a value of "C", the text should be Bold,green, and size 13 font.
Can anyone help?