approx = 1 is equivalent to approx = -1 except that when there is an exact match then the next closest of the 66 named colors is returned.įontColor(R1, approx) returns the font color of R1 as text. If approx = -1 then the closest of the 66 named colors is returned. If approx = 0 (default) an exact match among the 66 named colors must be found otherwise “unknown” is returned. RGBCode( text) returns the RGB value of the color named in textįillColor(R1, approx) returns the fill color of R1 as text. GreenRGB( n) returns the value (0-255) of the green component of the RGB value nīlueRGB( n) returns the value (0-255) of the blue component of the RGB value n RedRGB( n) returns the value (0-255) of the red component of the RGB value n fill) color or are bold.įillRGB(R1) returns the RGB background color value of the cells in range R1 (if the background colors of the cells differ then zero is returned).įontRGB(R1) returns the RGB font color value of the cells in range R1 (if the font colors of the cells differ then zero is returned). Real Statistics Functions: The Real Statistics Resource Pack contains the following functions that allow you to test whether cells in your spreadsheet have a specified font or background (i.e. Where Red, Green and Blue are integer values from 0 to 255 representing the intensity of that primary color. Colors in Excel are defined by an RGB (red/green/blue) code of the form
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |