View Single Post
 
Old 09-28-2020, 12:05 AM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,987
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

You need to look closely at the code and adapt it to your requirements. I'm not sure exactly which code you chose. Colours can be explicitly defined in RGB terms for more flexibility in defining a colour.

An example which would give you orange is
Code:
Case "Assisted": .Range.Cells(1).Shading.BackgroundPatternColorIndex = RGB(255,192,0)
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote