#1
|
|||
|
|||
How to highlight the row based on cell value?
Hi,
How to highlight the whole row based on a single cell value? I am using MS Excel 2007. I want to highlight the entire row if that row contains "CELL10" as blank cell. Please help me with the formula. Thanks. |
#2
|
||||
|
||||
Hi Leaner7,
You can do this with conditional formatting. Do note that highlighting a whole row is wasteful and can adversely affect workbook performance if the whole row isn't otherwise being used.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell | Frogggg | Excel | 1 | 10-25-2011 08:44 PM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
find - reading highlight - highlight all / highlight doesn't stick when saved | bobk544 | Word | 3 | 04-15-2009 03:31 PM |
Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |
highlight cell after checkbox | flatk | Word | 0 | 01-25-2007 12:32 PM |