Dear Forum,
I am trying to do a very simple Task of employing conditional Formatting in a Cell $B$2 which contains the following letters i.e characters.. [ A B C D E ]
They are coloured as follows :
A B C D E and this cell is filled with BLACK Fill Colour
Now If I enter 1 in the Cell $A$2, then the same colour scheme should remain in the Cell $B$2 but if I enter 2 then the formatting should change to BLUE FIll Colour and the Text to Yellow...
But when I tried changing the value in the Cell A2 to 2 , then only the first letter i.e "A" changes to Yellow Colour while rest does not change its colour i.e. remain the same...
Why is the entire cell B2 not getting formatted with all the contents?
And what is the remedy for the same?
Warm Regards
e4excel
Bookmarks