LinkBack URL
About LinkBacks
Hi , im using conditional formatting and using the following rule with the following formula: =$B2=“YES”
When I'm typing YES in column B , its Highlight the row above always, i tried a new sheet and also tried changing the row or text to no success.
Conditional Formatting -Not working well
Hi , im using conditional formatting and using the following rule with the following formula: =$B2=“YES”
When I'm typing YES in column B , its Highlight the row above always, i tried a new sheet and also tried changing the row or text to no success.
Welcome to the forum.
There are instructions at the top of the page explaining how to attach your sample workbook.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
The formula must reflect the first row in the applies to range.
So if the applies to range is from row 1 the formula should be
=$B1="Yes"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks