Is it possible to colour code a complete row, based on an entry in one cell?
When a cell under the column "STATUS", reads one of the various options, I require the entire row to automatically change to a specific colour, i.e:
When cell L4 reads "WON", I want the entire row to be filled green.
Likewise if the cell was to read "LOST", I would like the entire cell to be filled red.
Attached is an example.
Any ideas?
Thanks in advance.
Good time of day!
You may perform needed action with "Conditional Formatting". You will find example in the attachment.
How to apply:
1). Select needed range of table (without title) from 1-st to last row.
2). Define "Conditional Formatting" by formula:
3). Choose green color for this one and hit "OK" buttons.Formula:
Please Login or Register to view this content.
4). Repeat the same for "LOST" value with red color.
Best wishes and have a nice day!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks