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
Novice
 
Join Date: Jul 2013
Posts: 24
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,253
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
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 07:31 PM.


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