LinkBack URL
About LinkBacks
Hello. I have a table with the days of the week, days that I want to be filled with a color (conditional formatting) if they are found in column AH. I tried a few options but failed. Do you have any idea how I could do that? Thanks.
Conditional formatting if values are found in a column
Hello. I have a table with the days of the week, days that I want to be filled with a color (conditional formatting) if they are found in column AH. I tried a few options but failed. Do you have any idea how I could do that? Thanks.
Useas CF applied to $a$2:$ae$8Formula:
Please Login or Register to view this content.
(change the comma to a semi colon ; if you are using a non US Excel version)
Last edited by Pepe Le Mokko; 01-04-2022 at 10:14 AM.
Change CF formula into:
Formula:Please Login or Register to view this content.
should works.
Capture.JPG
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Re: Conditional formatting if values are found in a column
Thanks "Pepe Le Mokko" and "KOKOSEK". Worked.
Last edited by royeti; 01-04-2022 at 10:19 AM.
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks