Microsoft Office Forums Conditional Formatting

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-10-2019, 05:53 AM
Joanne Joanne is offline Conditional Formatting Windows 7 32bit Conditional Formatting Office 2010 32bit
Advanced Beginner
Conditional Formatting
 
Join Date: Jul 2013
Posts: 36
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 Conditional Formatting Windows 7 64bit Conditional Formatting Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
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 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)
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #3  
Old 01-24-2019, 03:15 AM
Joanne Joanne is offline Conditional Formatting Windows 7 32bit Conditional Formatting Office 2010 32bit
Advanced Beginner
Conditional Formatting
 
Join Date: Jul 2013
Posts: 36
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 Conditional Formatting Windows 7 64bit Conditional Formatting Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
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 lightPecoflyer is a glorious beacon of light
Default

You're welcome.
Please mark thread as solved ( see my sig)
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #5  
Old 01-28-2019, 02:30 AM
Joanne Joanne is offline Conditional Formatting Windows 7 32bit Conditional Formatting Office 2010 32bit
Advanced Beginner
Conditional Formatting
 
Join Date: Jul 2013
Posts: 36
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 Conditional Formatting Windows 7 64bit Conditional Formatting Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
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 lightPecoflyer is a glorious beacon of light
Default

It is explained in my signature
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #7  
Old 01-28-2019, 05:01 AM
Joanne Joanne is offline Conditional Formatting Windows 7 32bit Conditional Formatting Office 2010 32bit
Advanced Beginner
Conditional Formatting
 
Join Date: Jul 2013
Posts: 36
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 Conditional Formatting Windows 7 32bit Conditional Formatting Office 2010 32bit
Advanced Beginner
Conditional Formatting
 
Join Date: Jul 2013
Posts: 36
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 Conditional Formatting Windows 7 64bit Conditional Formatting Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
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 lightPecoflyer is a glorious beacon of light
Default

No worries
__________________
Please note I am not active on this forum anymore
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 Conditional Formatting solberg2004 Excel 2 01-27-2017 10:07 AM
Conditional Formatting Conditional formatting dayperson Excel 1 02-23-2016 09:07 AM
Conditional Formatting 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 05:24 AM.


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