Thread
:
Cell Value and Colours
View Single Post
12-04-2017, 06:15 AM
NBVC
Windows 10
Office 2013
The Formula Guy
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
You can use conditional formatting to match the colours.
Select the ranges to affect and then go to Home|Conditional Formatting|New Rule
Use the "Format only cells that contain" and enter your lower and upper ranges for each colour.
NBVC
View Public Profile
Find all posts by NBVC