Solved

Select specific RGB cell color

Posted on 2013-12-15
1
327 Views
Last Modified: 2013-12-15
Folks,
I would like to set the interior color of a cell to a defined color. I've tried the code below and it is not working:
Range("N22").Select
With Selection
.Interior.ColorIndex = RGB(83, 141, 213)
End With
Worksheets("CalAverLargestNumbers").Range("N22").Interior.ColorIndex = RGB(83, 141, 213)

Open in new window

0
Comment
Question by:Frank Freese
1 Comment
 

Accepted Solution

by:
Frank Freese earned 0 total points
ID: 39720396
figured it out:
Range("N22").Interior.color = RGB(83, 141, 213)
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question