Hi,
I want to find a value in B column and change the whole row colour into green. As attached, I want to find mango in B column. If the value is found, the full row should be filled with Green.
Hi,
I want to find a value in B column and change the whole row colour into green. As attached, I want to find mango in B column. If the value is found, the full row should be filled with Green.
Last edited by naflas; 12-09-2010 at 05:43 PM.
This should do what you want:
Please Login or Register to view this content.
Not all forums are the same - seek and you shall find
Hi
you can sue conditional formatting applies to entire row see attached
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks