Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 03-07-2014, 09:16 AM
SteveBump SteveBump is offline Conditional Formatting based on Value of Another Cell Windows 7 64bit Conditional Formatting based on Value of Another Cell Office 2010 64bit
Novice
Conditional Formatting based on Value of Another Cell
 
Join Date: Oct 2013
Posts: 24
SteveBump is on a distinguished road
Default

I was able to solve my problem. See the attached spreadsheet. Go to the tab 'Problem Solved'.

The first part was accomplished by simply using the "Use Formula" option in the Conditional Formatting function.

The second part was accomplished by setting up a Named Range and then testing against that in the Conditional Formatting "Use Formula" function.

Thanks to anyone who was working on this for me.

Steve
Attached Files
File Type: xlsx Conditional Formatting Example.xlsx (16.1 KB, 14 views)
Reply With Quote
 



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 based on Value of Another Cell Conditional formatting question based on cell date Cosmo Excel 2 04-08-2013 12:12 PM
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell Frogggg Excel 1 10-25-2011 08:44 PM
How can I fill cell color starting from Cell D5 using Conditional formatting instead Learner7 Excel 0 07-08-2010 05:50 AM
Conditional Formatting based on Value of Another Cell Conditional formatting of cell, Excel 2003 Scaffold Excel 2 05-01-2010 08:56 AM

Other Forums: Access Forums

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


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