Setting specific values to colors

		Microsoft Office Forums > Microsoft Excel > Excel
Setting specific values to colors

FAQ

Thread Tools

Display Modes

03-26-2015, 11:54 AM

Chancy

Windows 7 64bit Setting specific values to colors

Office 2010 64bit

Advanced Beginner

Join Date: Jan 2015

Posts: 32

Quote:

Originally Posted by macitaa

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!

« Previous Thread | Next Thread »

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
Unable to change font colors from theme colors	choy	Word	3	08-01-2012 09:12 PM
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 12:52 PM.