Conditional Formatting (Multiple Rows)
Hi All,
I'm trying my luck at conditional formatting but to no avail.
What I'm looking for is to highlight a cell if it falls under the condition I have (eg A1=F1, then A1 is highlighted). I'm trying to have it applied to multiple rows but I'm not able to figure it out (unless I do it one by one).
Is there a way for me to apply the condition on multiple rows and have the result show in an adjacent cell in the same row?
Thanks!
Last edited by taramo66; 07-23-2019 at 10:48 AM.
Hello and welcome to the forum.
Highlight the cells in the column that you want the Conditional Formatting to be applied to (starting with row 1) > Conditional Formatting > New Rule > Use a formula
=A1=F1
Format: Fill color of your choice > OK > OK
Originally Posted by 63falcondude
Thank you, 63falcondude. Been trying to work on this since yesterday. You rock.
You're welcome. Happy to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks