Help with Conditional formatting .........
I wish to enter the letter "w" - or "s" - in a single cell and for this cell to return the text "WhatsApp" or "SMS", and without any reference to another cell.
No highlighting - just black text on a white background.
I have tried various formulas - including the "Text that contains ..." and "Text that commences with...." - without any success.
Thanks.
Patrick.
You'd need to check for cell value is equal to s and then set the number format to a custom format of:
;;;"SMS"
and then set another format for w using:
;;;"WhatsApp"
Rory
Conditional Formatting does what it says on the tin ... formats the cell based on a condition or conditions. It cannot change the content of the cell.
You might be able to do it with AutoCorrect but that could affect every entry of the characters w and s.
I suspect VBA would be the way to go. A simple Worksheet Change Event handler monitoring the specific cell(s) would be required.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi Trev,
Thanks for your response.
Not clued up as regards VBA .........
Yes, I realise I have been trying to change the content of the cell - as you have said.
Patrick.
Do you need the content changed (if so, why?), or is just the displayed text ok?
Thanks Rory,
So how would i check for the cell values equal to s and w ?
Patrick.
In the CF rule. Choose 'Format only cells that contain' then select Cell Value, Equal To, and s (or w). Then in the Format section apply the relevant custom number format.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks