Thread: XLM FORMAT.COLOR command or . . .

Most of the color formatting questions on the board seem to focus on setting conditionals for automatic formatting.

I am trying to select a row from a variable in a known cell and use that as the Row number in an R1C1 concatenated reference to Format the color of a cell. This is the half of the project I am writing in XLM.

I can do this quite successfully for FORMAT.NUMBER, I just can't find a command for cell formating or a reference as to what arguments will pick what colors, etc.

This is the code that works perfectly for setting number format:

=SELECT("R"&!E1+10&"C4:R"&!E1+!E1+9&"C"&!C1&"")
=FORMAT.NUMBER("0.0%")

Thanks if anyone remembers or can point to a good XLM reference.

Brian

Originally Posted by romperstomper

You want the PATTERNS function.
=PATTERNS(pattern#,forecolor,backcolor,newUI)
is the syntax, so:
=PATTERNS(1,1,3,TRUE)
will apply pattern1 (solid fill), foreground colour black (irrelevant for pattern1) and back colour red. The TRUE bit refers to whether to use the Excel 5 settings rather than Excel 4.

For a reference, see the Macrofun help file.

He of the venerated tatoo, is there an html post of the macro fun file anywhere. I cannot open or run those .exe downloads from Microsoft. I already tried downloading that very file which you had recommended to someone else. I do my best to search previous answers before praying upon the kindness of strangers. I just can't believe there isn't some website reference for XLM somewhere . . .

Perhaps more important on the wish list is, is there a quick reference as to which colors are which numbers. Red is the 3rd down in the first column, so maybe you count down the column and then go to the top of the next column, but there is subset of colors at the bottom of the menu (I don't know if they are supposed to be brights or simple choice or why they are separate, but that confuses me as to which number will get which color. I'll experiment, and can probably logic it out, but if there is a reference for this command would be cool.

I'm ever hopeful although to say microsoft help files are underwhelming would be an understatement.

Best,

2B

Originally Posted by romperstomper

For a colour reference, see here. Note that that is the default palette, and may not apply to all workbooks.

Can you download Zip files?

Zips not a problem. But the mac doesn't recognize those .exe self extracting archives for windows.

thx.

2B