Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

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


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,
Reply With Quote
Old 01-10-2019, 08:40 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
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

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
and format as required

If in different columns

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

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. is not affiliated with Microsoft