Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-10-2011, 09:37 PM
Learner7 Learner7 is offline How to highlight the row based on cell value? Windows XP How to highlight the row based on cell value? Office 2007
Advanced Beginner
How to highlight the row based on cell value?
 
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 12-11-2011, 02:28 AM
macropod's Avatar
macropod macropod is offline How to highlight the row based on cell value? Windows 7 64bit How to highlight the row based on cell value? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft