Hi,
I have a conditional format for =L2="TRUE" but nothing happens when L2 has TRUE in the cell (it's the same for FALSE).
If I change it to =L2="anything else" and write anything else in L2 the conditional format works. Is there a way around this?
Hi,
I have a conditional format for =L2="TRUE" but nothing happens when L2 has TRUE in the cell (it's the same for FALSE).
If I change it to =L2="anything else" and write anything else in L2 the conditional format works. Is there a way around this?
Try this:
L2=TRUE
(no speech marks).
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
PERFECT! Thank you AliGW
Last edited by AliGW; 08-09-2017 at 05:07 AM. Reason: Unnecessary quotation removed.
No worries! A TRUE/FALSE return in a cell is not strictly text, so you were forcing Excel to look for the wrong type of value in the cell.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
One slight problem.
When I use L2=FALSE it formats (fills) the cell when it shows FALSE or it's blank. I could put another conditional format on top but i don't want to do that because it overwrites other formats.
Any ideas on how I can go around this?
Try this:
=AND(L2=FALSE,L2<>"")
That's worked wonders!! Thanks again
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks