Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel Cell Background and Font Color
How do you change the background and font color in cell?

I have 28,000 lines in an excel file that I want to format certain cells different colors based on 60 unique values.

I want to use various font color and background color combinations to sort the data better visually in one file.

Jimmy Vig
That appears to only apply to Excel 2007.

Any way with QM?

This works on a selected row:
Copy      Help
ExcelSheet es.Init

I don't understand how to specify the values.
Sorry I don't have excel to test.

Maybe Gint knows...
Can change some playing with flags:
ra.BorderAround(6 4 5 5)
ra.AutoFormat(Count 0 1 0 0 1 0)

Would like to change font color and weight. Italics would be nice. Background color would be awesome.

It would really be ideal if I could grab 60 unique combinations for the function to apply to the overall excel sheet.
Does this help any? Shows how to make certain cells Bold in C#

Can you convert C# to QM? I think Gint can some maybe.

Edit: Can this help?
Oh ended up being so easy.

I was getting tripped up because "ra.Font" was read only...

Once I put a "." after it... ra.Font.ColorIndex=(NUMBER)

Thanks. I got it good from here.
Easier then it seems sometimes! Good job.

Shout out to Gint, loving QM more and more as I go along! Thanks for all you do...are you working on updates yet?

Copy      Help
ExcelSheet es.Init
ARRAY(str) a

for _i 1 56
Quote:are you working on updates yet?

Yes, but now I cannot say when new QM will be ready.
I'm super excited for a new QM. I'm gonna buy a few more licenses too...I find my self wanting to use QM at every machine I sit down at. I should check into the portable USB version of QM a bit more. I think I would get a lot of use out of that! Your the best Gintaras!
Sweet sounds good Gint, you are the best! Can't wait..
One more here waiting for the new version Tongue
I second all the praise for Gintaras from the folks above. I have been using (and deploying) I am not sure if it's alpha or beta but it sure feels advanced over with many new functions that are critical to my newest workflows (e.g. hidden dialogs flag 128) and integration of a lot of stuff from the forum.

I don't notice any instability issues for my functions/macros/dialogs.

Worth trying out!!!

Gintaras Wrote:Who wants to test QM 2.3.3 alpha?

Beta should be released next month.

As far as color functions in VBscript for Excel, see this website for ideas of what to bring into QM as new member functions.

Justify text?

How do you do it?
Excel.Format does not support this alignment. Use Excel COM functions.

Macro Macro1791
Copy      Help
ExcelSheet es.Init
Excel.Range r=es._Range("2:2")

Forum Jump:

Users browsing this thread: 1 Guest(s)