Thread: Setting specific values to colors
View Single Post
 
Old 03-26-2015, 11:54 AM
Chancy Chancy is offline Windows 7 64bit 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