Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Generating Colour in Excel Cells

  1. Apr 26, 2015 #1
    Im trying to colour excel cells using (r,g,b) values.

    I understand its possible to do this through macros or through custom functions.

    Any suggestions / solutions?
  2. jcsd
  3. Apr 26, 2015 #2


    User Avatar
    2017 Award

    Staff: Mentor

    Macros are a good idea. There is a VBA function to color them. You can look it up, or record a macro and then analyze how it got recorded.
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook