Posted to microsoft.public.excel.programming

Rachael[_2_] Rachael[_2_] is offline

external usenet poster

Posts: 3

Changing the Cell Background Color when a keyword is entered

I'm trying to write a macro to change the cell background color when keywords are entered, something like

IF keyword = "north" THEN cell.Font.Color = Blu
IF keyword = "south" THEN cell.Font.Color = Re
IF keyword = "east" THEN cell.Font.Color = Gree
IF keyword = "west" THEN cell.Font.Color = Orang
IF keyword = "central" THEN cell.Font.Color = Pin

There will definitely be more than 3 keywords so I will not be able to use Conditional Formatting

Any help would be appreciated. Thanks.

Rachael

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
Changing Cell Background Color based on data from another cell	Speedy	Excel Discussion (Misc queries)	2	March 16th 09 04:10 PM
changing background color	Numa	Excel Discussion (Misc queries)	0	June 10th 08 04:36 PM
Changing Cell Background Color Depending on the Number	Matlock	Excel Discussion (Misc queries)	1	February 18th 08 12:41 AM
changing cell background color	okelbes	Excel Worksheet Functions	1	September 20th 06 03:28 PM
Changing background color based on different cell	djarcadian	Excel Discussion (Misc queries)	3	August 10th 06 10:44 PM

All times are GMT +1. The time now is 05:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us