conditional formatting w/ color as input vs output
 

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.

conditional formatting w/ color as input vs output
 

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.

conditional formatting w/ color as input vs output
 

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.

conditional formatting w/ color as input vs output
 

Use color index, something like this depending what you want
If Cells(1, 1).Interior.ColorIndex = 8 Then Cells(1, 2) = "Accounting"

if you want to test first
cells(1,1).interior.colorindex=8

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"HelloMoto" wrote:

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.