Hello:
I have column A with text like Tom_N,Mike_N,John_Y etc
I need to use CF so that to highlight to Red if the last character of the text is N, hightlight to Green if last charecter is Y
Please let me know if you have any questions.
Thanks.
Riz
Hello:
I have column A with text like Tom_N,Mike_N,John_Y etc
I need to use CF so that to highlight to Red if the last character of the text is N, hightlight to Green if last charecter is Y
Please let me know if you have any questions.
Thanks.
Riz
Use these as your CF formulae:
=RIGHT(A1,2)="_N"
and
=RIGHT(A1,2)="_Y"
Last edited by Glenn Kennedy; 12-22-2015 at 10:18 AM. Reason: Attach file
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Hello Glenn:
THanks a lot..
works
Riz
Cheers. At least you didn't pick up my first answer which was horribly wrong!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks