Apologies if this has been answered, but the search keeps timing out
I have a row that has lookup range values from 1-100 which needs to change colour as well as text depending on the numerical value.
Example: If the cell contains a value between 1-17, it must be green and display LOW instead of the number (eg 5). 18-39 would be yellow and must say MEDIUM, 40-63 must turn orange and read HIGH. 64-100 must change to red and read CRITICAL.
I can change the colour with conditional formatting (assuming I make the base colour green), but I can't seem to change the text. I am quite useless when it comes to VBA and not even sure where to start.
I'd appreciate it if someone could respond on how I can do this.
I have a row that has lookup range values from 1-100 which needs to change colour as well as text depending on the numerical value.
Example: If the cell contains a value between 1-17, it must be green and display LOW instead of the number (eg 5). 18-39 would be yellow and must say MEDIUM, 40-63 must turn orange and read HIGH. 64-100 must change to red and read CRITICAL.
I can change the colour with conditional formatting (assuming I make the base colour green), but I can't seem to change the text. I am quite useless when it comes to VBA and not even sure where to start.
I'd appreciate it if someone could respond on how I can do this.