PC Review


Reply
Thread Tools Rate Thread

Condition Cell Shading

 
 
Marc
Guest
Posts: n/a
 
      29th May 2008
How do I format a cell to either change the font color or shade the cell when
it is below the value of another cell?
 
Reply With Quote
 
 
 
 
Ronx
Guest
Posts: n/a
 
      29th May 2008
In FrontPage? Requires server-side scripting or JavaScript to read the
values of the cells and apply CSS styles accordingly.

In Excel? Best to ask in an Excel newsgroup or forum.

--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

http://www.rxs-enterprises.org/fp




"Marc" <(E-Mail Removed)> wrote in message
news:33F09601-F774-47F2-8A10-(E-Mail Removed):

> How do I format a cell to either change the font color or shade the cell when
> it is below the value of another cell?


 
Reply With Quote
 
Rob Giordano \(Crash\)
Guest
Posts: n/a
 
      30th May 2008
In Excel?...Format | Conditional Formatting


--
~~~~~~~~~~~~~~~~~~
Rob Giordano
Microsoft MVP Expression






"Marc" <(E-Mail Removed)> wrote in message
news:33F09601-F774-47F2-8A10-(E-Mail Removed)...
> How do I format a cell to either change the font color or shade the cell
> when
> it is below the value of another cell?



 
Reply With Quote
 
Andrew Murray
Guest
Posts: n/a
 
      30th May 2008
Is this a FrontPage question.....?

Sounds like you want the Excel group.


"Marc" <(E-Mail Removed)> wrote in message
news:33F09601-F774-47F2-8A10-(E-Mail Removed)...
> How do I format a cell to either change the font color or shade the cell
> when
> it is below the value of another cell?


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: How to change cell shading/fill based on value in another cell? Bob Umlas Microsoft Excel Discussion 0 11th Nov 2009 04:08 PM
Conditional Cell Shading (based on the shading of other cells) =?Utf-8?B?VHViYnk=?= Microsoft Excel Worksheet Functions 2 20th Jun 2006 10:03 PM
when adding shading to a cell only words are shading =?Utf-8?B?MUthdGhpZU0=?= Microsoft Word Document Management 3 7th Oct 2005 07:56 PM
change cell shading whenever contents different from previous cell =?Utf-8?B?em9vZXloYWxsbmU=?= Microsoft Excel Misc 3 6th Jun 2005 09:59 PM
Condition is true in one cell, give me same condition in another T. Harris Microsoft Excel Misc 1 28th May 2004 08:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:29 AM.