Setting specific values to colors

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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:51 PM.