Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Conditional Formatting for a change in number Conditional Formatting for a change in number
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 07-27-2013, 12:16 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Conditional Formatting for a change in number Windows 7 64bit Conditional Formatting for a change in number Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Select the range starting in B1 and try =A$1>B$1 for the red condition and =A$1<=B$1 for the green condition
__________________
Using O365 v2503 - 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
  #2  
Old 07-27-2013, 07:58 AM
Alaska1 Alaska1 is offline Conditional Formatting for a change in number Windows 7 64bit Conditional Formatting for a change in number Office 2007
Competent Performer
Conditional Formatting for a change in number 		 
Join Date: Nov 2011
Posts: 110
Alaska1 is on a distinguished road
Default Conditional Formatting for a change in number
I have attached a sample file. Is this a possible way to set it up?
Attached Files
File Type: xls Book1.xls (17.5 KB, 17 views)
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting value change of same cell tcalhoun Excel 0 04-25-2013 07:25 AM
conditional formatting otuatail Excel 1 06-06-2012 05:07 AM
Conditional Formatting for a change in number Conditional Formatting. Laurie B. Excel 6 04-09-2012 05:01 PM
Conditional Formatting for a change in number 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

Other Forums: Access Forums

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

Contact Us - Privacy Statement - Top

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