Hello,
I am looking for code to highlight cells in column B based on cells in column R = "YES".
conditional formatting will not work for my specific need.
Thank you,
Hello,
I am looking for code to highlight cells in column B based on cells in column R = "YES".
conditional formatting will not work for my specific need.
Thank you,
I am sure you are right, but curious to know why you think that CF won't work for you.
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.
Hi phbryan, It might be helpful to know why conditional formatting will not work.
Squeaky
Hard to explain, so I've attached an example. This example sheet is sorted a particular way, and "WO #" is highlighted via CF based on column M.
However, if you change the sorting in any column, then the value in M changes as well. For example, WO73323 and WO75201 are highlighted. If you sort column B ascending, they are no longer highlighted.
Hi phbryan, when you sort, are you sorting that single column only and not the whole sheet? When I sort using the AZ arrow, I select expand and it sorts correctly. If I select the entire field and select sort, then the b column and select a-z it works.
Also, if I select the filter arrow and select sort on column B it works. If I sort B and do not select the rest of the columns it does not work.
The yes/no answers are calculated based on the information in the other cells and nothing is calculated based on the B row. So when you change the order of B without the other fields, it aligns with a different (or the same) answer in M.
Last edited by Squeaky; 09-28-2023 at 03:58 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks