Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Find Colour of Cell...

0 views
Skip to first unread message

Andri

unread,
Apr 16, 2007, 9:28:01 AM4/16/07
to
Dear All,

I need to check certain cell, if the format colour is Red, i want to put
figure 1, Black = 2, Blue =3.

Please help by using formula?

Thank you for your kind attention.

Andri

Richard

unread,
Apr 16, 2007, 9:36:03 AM4/16/07
to
See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

This should point you in the right direction, advice taken from an earlier
post.

Mike

unread,
Apr 16, 2007, 9:46:03 AM4/16/07
to
You first need to return the colour and this requires a function such as:-

http://www.cpearson.com/excel/colors.htm

If you were then testing A1 you could call this function with this formula
in A1

=IF(CELLCOLORINDEX(A1,FALSE)=3,1,IF(CELLCOLORINDEX(A1,FALSE)=1,2,IF(CELLCOLORINDEX(A1,FALSE)=5,3,"")))

When changing the cell colour the function would need to be called again by
pressing F9. Also choose your font colour wisely because you are checking fro
black so a black font won't work.

Mike

Andri

unread,
Apr 16, 2007, 11:18:03 AM4/16/07
to
Dear Mike,

Thank you..it works...

Brgds,andri

Andri

unread,
Apr 16, 2007, 11:22:01 AM4/16/07
to
Dear Richard,

Thank you.

Brgds,andri

0 new messages