I have a table with three columns which I have applied conditional formatting to. The formula works if I make all of the 'profile engagement scores' lower case, but if they are upper case and the letters in the formula are also upper case, the cells are not highlighted correctly.
How do I fix this so it works when the profile engagement scores are in upper case?Untitled.jpg
Use the LOWER function to ensure case is consistent.
That isFormula:
Please Login or Register to view this content.
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
Sorry but where about should I be putting this formula? Within the current conditional formatting formula somewhere?
All works fine when the profile scores are in lower case but not when they are in upper case, which is what I want them to be in.
zobrien
Pls take some minutes to read forum rules, because:
Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.
Thread Closed.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks