Help for EXCELL needed.

Talk about anything here as long as it is not against the rules. Post count not affected.
Dec 16th, 2014, 5:41 pm
#2307661 by Guy1731
Image

Anybody can give me an idea how I can get a number "1" in cell D2 because B2 is green, and a number "2" in cell D4 because B4 is blue?

Thank you.
Dec 16th, 2014, 5:41 pm

Image
Dec 16th, 2014, 9:37 pm
#2308152 by andrewkc
If you are using a newer version of excel you can use for example...
If(CellColour(4,4)=6,"Yellow","Not Yellow")
Not sure of the code for green or blue but the formula creator will help you.
Dec 16th, 2014, 9:37 pm
Dec 16th, 2014, 11:11 pm
#2308292 by Guy1731
Thank you, but I use Excell 2007, and there's no If (celcolour... ) function available.
Dec 16th, 2014, 11:11 pm

Image
Jan 9th, 2015, 6:11 pm
#2359241 by Guy1731
Aha. Wonderful. I will try that tonight. Thanks! ;)
Jan 9th, 2015, 6:11 pm

Image
Jan 10th, 2015, 1:03 pm
#2361116 by Guy1731
julieann313 wrote:I've done this several times for work and have found this link very useful.

http://stackoverflow.com/questions/2000 ... -of-a-cell

Helas, the function 'GET.CELL' as described in that topic doesn't work in excel 2007.

Maybe it's time for an upgrade...
Jan 10th, 2015, 1:03 pm

Image