Simple If Function

**test1986** · 12-07-2006, 10:21 AM

Hi all,

I have tried to write a If function which will look in cell A3 and if it i highlighted then i want it to say "Yellow" and if not then i want it to say "clear".

I have written:

Please Login or Register  to view this content.

And this comes up with #NAME?.

Any Suggestions would be much appreciated.

Test1986

pinmaster · 12-07-2006, 11:04 AM

Hi

You would need to install an add-in that can recognize a cell's backgound color, not sure there is one outhere tho. Can you explain why A3 is highlighted and how, maybe there is a better way.

Jean-Guy

**Carim** · 12-07-2006, 11:08 AM

Hi,

It is a VBA solution (event macro or UDF) not just a formula ...

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

Carim

**Bryan Hessey** · 12-07-2006, 11:39 AM

Originally Posted by test1986

Hi all,

I have tried to write a If function which will look in cell A3 and if it i highlighted then i want it to say "Yellow" and if not then i want it to say "clear".

I have written:

Please Login or Register  to view this content.

And this comes up with #NAME?.

Any Suggestions would be much appreciated.

Test1986

Hi,

im the worksheet tab, rightmouse and 'View Code'
copy this code there

Please Login or Register  to view this content.

then double-click a cell to see it's colour.

hth
---

Simple If Function

LinkBack

Thread Tools

Rate This Thread

Display

Simple If Function

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions