PC Review


Reply
Thread Tools Rate Thread

how do i change cell colour by value in excell

 
 
Kram
Guest
Posts: n/a
 
      16th Jan 2009
I am trying to varie the colour of a cell depending on the returned value of
that cell. The cell has a few simple sums within it culd anybody help with a
very inexperianced user
Thanks
 
Reply With Quote
 
 
 
 
Eduardo
Guest
Posts: n/a
 
      16th Jan 2009
Hi,
You can use conditional formating, let's say your cell whit the formula is
in A1 and the cell you want to change color in A2, if the result you are
looking for is if that value is greater than 1 enter position yourself on
Cell A2 and in conditional formating enter A1>1, then choose the color

"Kram" wrote:

> I am trying to varie the colour of a cell depending on the returned value of
> that cell. The cell has a few simple sums within it culd anybody help with a
> very inexperianced user
> Thanks

 
Reply With Quote
 
JLGWhiz
Guest
Posts: n/a
 
      16th Jan 2009
Maybe this site will help you understand how it works.

http://office.microsoft.com/en-us/ex...CL100570551033

"Kram" wrote:

> I am trying to varie the colour of a cell depending on the returned value of
> that cell. The cell has a few simple sums within it culd anybody help with a
> very inexperianced user
> Thanks

 
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
Change cell colour on formula result change, no conditional format roster_jon Microsoft Excel Programming 0 2nd Dec 2008 12:11 PM
if cell colour is then change cell colour in range =?Utf-8?B?dGlnZXI=?= Microsoft Excel Programming 2 30th May 2007 05:32 AM
change current cell colour based on the value of adjacent cell on other worksheet Rits Microsoft Excel Programming 2 23rd Nov 2006 11:57 AM
Excell and changing cell colour =?Utf-8?B?c2Fkc2Zhbg==?= Microsoft Excel Programming 7 17th Oct 2006 04:39 PM
change a cell background colour to my own RGB colour requirements =?Utf-8?B?U3RlcGhlbiBEb3VnaHR5?= Microsoft Excel Misc 4 16th Jun 2006 01:08 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:23 AM.