Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-07-2015, 12:35 AM
technofrank technofrank is offline Conditional formatting Windows 7 64bit Conditional formatting Office 2007
Novice
Conditional formatting
 
Join Date: Mar 2015
Posts: 8
technofrank is on a distinguished road
Default Conditional formatting

Hi All,

Please help me about conditional formatting, suppose I will type an exact word or value "TEST" in cell A2. Is there a way after typing the word "TEST" in cell A2 the cells from A1 to A5 will change to my desired fill color?



I know there's a way out here please help.

I am using MS OFFICE 2007

Thank you in advance.
Reply With Quote
  #2  
Old 06-07-2015, 07:13 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

Select the range A1to A5 in the CF wizard and enter =$a2="test" as condition. Select your format - Done
__________________
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 06-08-2015, 12:45 AM
technofrank technofrank is offline Conditional formatting Windows 7 64bit Conditional formatting Office 2007
Novice
Conditional formatting
 
Join Date: Mar 2015
Posts: 8
technofrank is on a distinguished road
Default

Thanks for your reply, but it's not working.
Reply With Quote
  #4  
Old 06-08-2015, 03:15 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

Then post a sample sheet showing what you want to achieve. ( "it's not working" does not really help to help you)
__________________
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

Tags
conditional formatting, excel 2007, ms office 2007

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting Conditional formatting bbutl027 Excel 15 12-05-2016 08:56 PM
Conditional formatting Conditional formatting marif300 Project 9 09-23-2014 07:23 AM
Conditional formatting Conditional formatting that ignores other formatting rules info_guy2 Excel 1 07-03-2014 10:07 AM
Conditional formatting zanat0s Excel 4 01-20-2012 03:30 AM
Conditional Formatting namedujour Excel 3 08-25-2011 01:46 PM

Other Forums: Access Forums

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


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