By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,442 Members | 1,340 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,442 IT Pros & Developers. It's quick & easy.

working whit excel

P: n/a
hi
i am saeed rezaei sr*********@yahoo.com

who is knowh how i can changing the excel cells backcolor.

now i can working whit excel but still i cant change the backcolor of cells.
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"saeed rezaei" <sr*********@yahoo.com> schrieb:
who is knowh how i can changing the excel cells backcolor.

now i can working whit excel but still i cant change the
backcolor of cells.


Give the Excel programmers a try:

<URL:news://news.microsoft.com/microsoft.public.excel.programming>

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>
Nov 21 '05 #2

P: n/a
Try the following out:
xlRG = xlWS.Cells(row, 7)
xlRG.Font.Bold = True
xlRG.Font.Color = 255 ' sets font color to RED
xlRG.Interior.ColorIndex = 34 ' light blue
xlRG.Interior.Pattern = Excel.XlPattern.xlPatternSolid

where xlRG is a range object and xlws is the worksheet object
"Herfried K. Wagner [MVP]" wrote:
"saeed rezaei" <sr*********@yahoo.com> schrieb:
who is knowh how i can changing the excel cells backcolor.

now i can working whit excel but still i cant change the
backcolor of cells.


Give the Excel programmers a try:

<URL:news://news.microsoft.com/microsoft.public.excel.programming>

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.