Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-18-2014, 12:43 PM
teza2k06 teza2k06 is offline Conditional Formatting Windows 7 64bit Conditional Formatting Office 2010 32bit
Advanced Beginner
Conditional Formatting
 
Join Date: Feb 2013
Posts: 31
teza2k06 is on a distinguished road
Default Conditional Formatting

Hi All,


I have a spreadsheet that i have made, but i am having trouble setting up 1 conditional format.
I have 2 set up already, so that when the cell has Suspended in the cell it then highlights that cell red, and i have a count at the top which counts how many cells have Suspended written in it.

How can i set it up that when the cell has Suspended written in it, it fills the row red and not just the cell?

Any help would be great

Thanks
Reply With Quote
  #2  
Old 01-18-2014, 01:09 PM
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,418
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

Suppose your range is A1: D100 and you want to check the presence of your keyword in col B.
Select the ENTIRE range A1: D100, and use =$B1="suspended" as formula for the CF then format as needed.
The key is the presence of the absolute reference to col B

You will have to change these values according to your needs of course
Reply With Quote
  #3  
Old 01-18-2014, 02:54 PM
teza2k06 teza2k06 is offline Conditional Formatting Windows 7 64bit Conditional Formatting Office 2010 32bit
Advanced Beginner
Conditional Formatting
 
Join Date: Feb 2013
Posts: 31
teza2k06 is on a distinguished road
Default

If you could help

I will want it to fill the row from columns A to AQ, and the suspended field is column G
Reply With Quote
  #4  
Old 01-19-2014, 02:34 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,418
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

In my example replace the range with A1:AQ100 (or whatever row numbers) and $B1 with $G1 ( or whatever first row number)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting Conditional Formatting. Laurie B. Excel 6 04-09-2012 05:01 PM
Conditional formatting zanat0s Excel 4 01-20-2012 03:30 AM
Conditional Formatting Conditional formatting with AND, OR Lucky Excel 2 10-03-2011 11:41 PM
Conditional Formatting Conditional Formatting namedujour Excel 3 08-25-2011 01:46 PM
Conditional Formatting help with conditional formatting Snvlsfoal Excel 3 07-03-2011 11:55 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 07:07 PM.


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