Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-10-2019, 05:53 AM
Joanne Joanne is offline Windows 7 32bit Office 2010 32bit
Advanced Beginner
 
Join Date: Jul 2013
Posts: 34
Joanne is on a distinguished road
Default Conditional Formatting

Hi



I have used conditional formatting to highlight a particular cell but is it possible to format a spreadsheet so that if a particular word (in this case "withdrawn") is entered into a cell, the whole row is highlighted, not just that cell?

Many thanks,
Jo
Reply With Quote
  #2  
Old 01-10-2019, 08:40 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,335
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

I would not advise using CF on an entire sheets, as it will slow your sheet down tremendously
Does your word always appear in the same column ( different rows)?

If so, select a number of rows starting in row1 ( again, not too many and not necessarily all columns) at once then use the following assuming your words appear in col C
=ISNUMBER(SEARCH("withdrawn",$C1))
and format as required


If in different columns
try

=SUMPRODUCT(--NOT(ISERROR(SEARCH("withdrawn",$A1:$Z1))))>0
as CF
(there should be something more elegant)
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #3  
Old 01-24-2019, 03:15 AM
Joanne Joanne is offline Windows 7 32bit Office 2010 32bit
Advanced Beginner
 
Join Date: Jul 2013
Posts: 34
Joanne is on a distinguished road
Default Conditional Formatting

Hi Pecoflyer

Apologies for the delay. This worked perfectly for me.

Many thanks,
Joanne
Reply With Quote
  #4  
Old 01-24-2019, 07:41 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,335
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

You're welcome.
Please mark thread as solved ( see my sig)
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #5  
Old 01-28-2019, 02:30 AM
Joanne Joanne is offline Windows 7 32bit Office 2010 32bit
Advanced Beginner
 
Join Date: Jul 2013
Posts: 34
Joanne is on a distinguished road
Default Marking as solved?

Hi

Apologies if it is obvious, but I can't see how to mark a problem as solved.
Reply With Quote
  #6  
Old 01-28-2019, 03:48 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,335
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

It is explained in my signature
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #7  
Old 01-28-2019, 05:01 AM
Joanne Joanne is offline Windows 7 32bit Office 2010 32bit
Advanced Beginner
 
Join Date: Jul 2013
Posts: 34
Joanne is on a distinguished road
Default Marking as solved?

Still not getting it. When I click on "Thread Tools", I just get "Printable Version" option.
Reply With Quote
  #8  
Old 01-28-2019, 05:02 AM
Joanne Joanne is offline Windows 7 32bit Office 2010 32bit
Advanced Beginner
 
Join Date: Jul 2013
Posts: 34
Joanne is on a distinguished road
Default

Apologies, please ignore the last message!
Reply With Quote
  #9  
Old 01-28-2019, 08:30 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,335
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

No worries
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting SarahH7 Excel 5 06-27-2018 11:43 AM
Conditional Formatting solberg2004 Excel 2 01-27-2017 10:07 AM
Conditional formatting dayperson Excel 1 02-23-2016 09:07 AM
Conditional formatting that ignores other formatting rules info_guy2 Excel 1 07-03-2014 10:07 AM
Conditional Formatting jdc15371 Excel 2 06-26-2014 06:34 AM


All times are GMT -7. The time now is 02:35 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft