Cell colors

[kocevskii]

Hello
I am using office 2016
I have one column I have data marked with cell colors (yellow, orange ... etc) or style (bad, good..... etc).

I need in second column to add next to each cell, text like cell color from the first column.
Text in second column will be like (YELLOW, ORANGE, BAD, GOOD, etc)

Is this possible with some formula because my first column is very long and has more colors and styles.

[CheeseSandwich]

I think a VBA solution would be best for this situation as formula can't get the colour nor style from the cell.

The VBA solution could be a subroutine that does it all at once or a custom function that works similar to a formula but is created manually using VBA.

I think a good start here would be an example workbook with an example of each colour/ style that would be used along with the word you would like to see beside it.

[dosydos]

this is the VBA custom function i use for cell color.

Please Login or Register  to view this content.

=cellcolor(A1) Replace A1 with the cell that has the color

This will get you the number of the color (1-56) of the referenced cell based on this color graph: https://learn.microsoft.com/en-us/of...cel.colorindex

then just do an if statement or lookup to change 6 to Yellow or 4 to Green...etc