Microsoft Office Forums Conditional formatting

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,397
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 lightPecoflyer is a glorious beacon of light
Default

Select the range A1to A5 in the CF wizard and enter =$a2="test" as condition. Select your format - Done
__________________
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
  #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,397
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 lightPecoflyer is a glorious beacon of light
Default

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

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


All times are GMT -7. The time now is 09:14 AM.


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