LinkBack URL
About LinkBacks
Hello,
Can you please help me how to set a conditional format that when I enter an specific text with the firt letter Z then it will higlight from A-H cells.
See my sample worksheet.
Thank you in advance.
Hello,
Can you please help me how to set a conditional format that when I enter an specific text with the firt letter Z then it will higlight from A-H cells.
See my sample worksheet.
Thank you in advance.
Select entire columns A:H and use the CF formula: =LEFT($H1,1)="Z"
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
Great! Thank you so much.
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks