What is the code for this? Hopefully it's a short one.

"John Bundy" wrote:

You can do this through code but not conditional formatting.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Tom" wrote:

There is a lot of info on how to change a cells color with conditional
formatting function. Is it possible to do the opposite? That is, can the
cells color be used as the input instead of a cell value? example, If cell A
is shaded blue, then roll B will be shaded orange.