#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 202
Default color

I am desiging a data shee and i want to changes the color of a cell based on
the valuse of anthor cell.

ex. if "cell m34" is equal to 0 then "cell p21" is white, if cell m34 less
than 1548, then "cell P21" is yellow

Can this be done? If so, please help me out.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default color

Hi
see your other posts
P.S.: please don't multipost

--
Regards
Frank Kabel
Frankfurt, Germany


Dennis wrote:
I am desiging a data shee and i want to changes the color of a cell
based on the valuse of anthor cell.

ex. if "cell m34" is equal to 0 then "cell p21" is white, if cell m34
less than 1548, then "cell P21" is yellow

Can this be done? If so, please help me out.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Powerpoint / Excel: custom pp RGB color doesn't match identical Excelcustom RGB color mikewillnot Charts and Charting in Excel 1 February 26th 08 05:22 PM
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
My fill color and font color do not work in Excel Std Edition 2003 chapstick Excel Discussion (Misc queries) 1 September 11th 05 08:48 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


All times are GMT +1. The time now is 04:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"