Hi. I have a simple bus timetable. I select a stop by data validation in cell A2, and would like to use CF to highlight the corresponding row please. I've used "Portland Street" as an example, formatted manually. Thank you.
Hi. I have a simple bus timetable. I select a stop by data validation in cell A2, and would like to use CF to highlight the corresponding row please. I've used "Portland Street" as an example, formatted manually. Thank you.
Hi,
Cond Format In A4:Formula:Please Login or Register to view this content.
Apply it to the whole table
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Select A4:BQ53
Conditional Formatting>New Rule> Use Formula
=$A4 = $A$2
Format as desired
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks