EZERYDR
05-19-2011, 07:25 PM
Any ideas on how to retrieve the CellColor value of a range of cells that have been colored manually using Excel then use that value to answer "Y" in another range of cells?
The users will be selecting various cells in a column and highlighting those cells in a particular color (i.e., blue) using the basic color selection tool in Excel. I need the VBA code to read the value of the color in the highlighted cells and use that value to input a "Y" in another cell on the respective row.
For example, If Range("A" & Col).ColorCell = Blue Then Range("D" & Col) = "Y".
Thanks!!
The users will be selecting various cells in a column and highlighting those cells in a particular color (i.e., blue) using the basic color selection tool in Excel. I need the VBA code to read the value of the color in the highlighted cells and use that value to input a "Y" in another cell on the respective row.
For example, If Range("A" & Col).ColorCell = Blue Then Range("D" & Col) = "Y".
Thanks!!