Could someone please help me, i have done a lot of work with excel, but have come across a problem that is driving me crazy.
What i am trying to do is i have a cell it has a "0" in it and the color of the cell is red, if i change the number to "15", the cell changes color to blue thanks to conditional formating.
But what i want to do now is if i change the "15" to BOLD
, the cell will change color to green using conditional formating.
Does anyone know of a way to do this? Any solution would be greatly appreciated.
I simply need a way for excel to register that the number or letters have changed to BOLD
and return a result.
I hope the above paragraph made sense with what im trying to do.