Posted to microsoft.public.excel.programming

ChrisG[_2_] ChrisG[_2_] is offline

external usenet poster

Posts: 2

Help Evaluating Cell Values and Changing Colors

I have a column B1 to B? with one of a possible 5 string
values in each cell. I wish to evaluate the value in the
B-cell and depending on that value is then change the
color of font in the corresponding cell in column C.

Note: B? means Column B is of variable length, could be
30 and next day could be 40.

Thanks in advance

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 colors	Joebeone	Excel Discussion (Misc queries)	1	February 11th 10 07:17 PM
Cell colors or text color changing when date in cell gets closer.	Chase	Excel Worksheet Functions	5	October 19th 06 08:57 AM
Changing cell colors to correspond to different dates	emtp6738	Excel Worksheet Functions	2	September 26th 06 02:40 AM
changing cell colors with formula	sflcowboy78	Excel Worksheet Functions	2	October 2nd 05 01:19 AM
Cell contents changing colors	Barmaley	Excel Programming	0	July 8th 03 03:24 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us