Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-25-2015, 03:16 AM
macitaa macitaa is offline Setting specific values to colors Windows 7 64bit Setting specific values to colors Office 2007
Novice
Setting specific values to colors
 
Join Date: Mar 2015
Posts: 1
macitaa is on a distinguished road
Default Setting specific values to colors


I want to specify certain values to a specified color and i do not know how to go about this. E.g. value of 60 - black color and value of 30 - red color. How do i do this?
Reply With Quote
  #2  
Old 03-25-2015, 05:46 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Setting specific values to colors Windows 7 64bit Setting specific values to colors 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

You could perhaps start with this UDF
__________________
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 03-26-2015, 11:54 AM
Chancy Chancy is offline Setting specific values to colors Windows 7 64bit Setting specific values to colors Office 2010 64bit
Advanced Beginner
 
Join Date: Jan 2015
Posts: 32
Chancy is on a distinguished road
Default

Quote:
Originally Posted by macitaa View Post
I want to specify certain values to a specified color and i do not know how to go about this. E.g. value of 60 - black color and value of 30 - red color. How do i do this?
You could do this with conditional formatting.

Home/Conditional Formatting/

Highlight cells rules... follow the instructions!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup multiple values and compare different scenarios to get a specific result mws Excel 5 05-24-2014 04:52 AM
Mouseover cell to indicate mouse pointer location based on Specific Row/Column values bolandk Excel 1 05-15-2014 08:22 AM
Print attachment when it arrive in specific folder with specific subject visha_1984 Outlook 1 01-30-2013 10:42 AM
Setting specific values to colors Unable to change font colors from theme colors choy Word 3 08-01-2012 09:12 PM
Setting specific values to colors Setting focus to specific word document from UserForm SaneMan Word VBA 5 04-01-2011 03:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:53 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