Posted to microsoft.public.excel.misc

Ms_M_o_n_i_c_a Ms_M_o_n_i_c_a is offline

external usenet poster

Posts: 13

can you use colors when creating forumla?

example: i want cell a2 to highlite green if a1 is equal to 1

conditional formatting only works for one cell.
--
I will Excel at Excel!

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
Worksheet formatting (fill colors & text colors) disappeared	sweettooth	Excel Discussion (Misc queries)	2	June 24th 08 01:16 AM
2007 Colors - I want 2003 Colors	Austin22	Excel Discussion (Misc queries)	0	October 16th 07 02:49 PM
Lost highlighting and font colors; background colors on web pages	Jan in Raleigh	Excel Discussion (Misc queries)	2	July 31st 07 09:10 PM
Forumla Help	streetboarder	Excel Discussion (Misc queries)	12	January 27th 06 11:50 PM
Can't format font colors or cell fill-in colors	canoeron	Excel Discussion (Misc queries)	3	August 22nd 05 11:46 PM

All times are GMT +1. The time now is 12:44 PM.

About Us

"It's about Microsoft Excel"