Hi there,
I will start off with the fact that I am a semi-newbie with Excel and so happy that I found this site. I would like to do the following (if possible):
One worksheet will list a series of questions in column A for an account. Column B on the same worksheet will have Green, Yellow, and Red drop down to indicate status alerts. Question one: When I pick a color, can it change the cell to that color or the letters to that color?
I will also have a separate worksheet that will list each account by name in column A. I would like the colors or color words to show in Column B if any of the questions on the first worksheet show up red or yellow (maybe have column B = red, Column C = yellow or something). Is this possible?
Thanks!
I will start off with the fact that I am a semi-newbie with Excel and so happy that I found this site. I would like to do the following (if possible):
One worksheet will list a series of questions in column A for an account. Column B on the same worksheet will have Green, Yellow, and Red drop down to indicate status alerts. Question one: When I pick a color, can it change the cell to that color or the letters to that color?
I will also have a separate worksheet that will list each account by name in column A. I would like the colors or color words to show in Column B if any of the questions on the first worksheet show up red or yellow (maybe have column B = red, Column C = yellow or something). Is this possible?
Thanks!
