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: 37
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,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
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
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
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: 37
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,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

In my example replace the range with A1:AQ100 (or whatever row numbers) and $B1 with $G1 ( or whatever first row number)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
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 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

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


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