Hi Guys,
I have a set of data in which i want to match, if column O3 and Column AC3 is equal to a specific value
Then i want both the rows in each column to get highlighted by a specific colour.
Hi Guys,
I have a set of data in which i want to match, if column O3 and Column AC3 is equal to a specific value
Then i want both the rows in each column to get highlighted by a specific colour.
Maybe:
=AND($O3="value",$AC3="value")
put it in Conditional formatting formula box and formatted with designed colour.
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks