=ColorCell(Color) - ExcelBanter

Posted to microsoft.public.excel.programming

Ola[_5_]

external usenet poster

Posts: 7

=ColorCell(Color)

I want to create a function that Colors the Active Cell based on a certain
criteria.
Example:
A1: 10
B1: =ColorCell(A1)

I want to use it instead of conditional formatting since I want the
flexibility - so I can use all 56 colors. Also I want =ColorCell(A1) to
return "" (=blank)

Is this possible?
Ola

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't format cell color/text color in Office Excel 2003 in fil	Tony S	Excel Discussion (Misc queries)	1	December 21st 07 01:41 PM
Can't format cell color/text color in Office Excel 2003 in files .	albertaman	Excel Discussion (Misc queries)	0	February 16th 06 03:56 AM
Excel 2003 will not display color fonts or color fill cells	DaveC	Excel Worksheet Functions	1	April 11th 05 04:38 PM
My excel 2003 wont let me fill cells with color or color the tabs.	trizog	New Users to Excel	2	February 22nd 05 06:43 PM
Browse Forms Controls and change TextBox color based on cell color	StefanW	Excel Programming	2	November 21st 04 07:06 PM

All times are GMT +1. The time now is 08:38 AM.

Menu

About Us