Search : in
By :

How to make a cell change colour

Last answer on Oct 5, 2009 11:39:37 am BST SirMinstral, on Jun 1, 2009 7:06:03 pm BST 
 Report this message to moderators

Hello,
i am trying to make a money sheet on excel to sort out my money.

i already have the basice sheet made and i have a sum in the box i want to use. i want to keep the same sum in the cell but i also want to add another to make the cell change colour to green if the amount is above 0 and red if the number turns into a negative below 0

can anyone advise me on this

Configuration: Windows Vista Internet Explorer 8.0 Microsoft Office 2007

Best answers for « How to make a cell change colour » in :
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
Manage XP and Vista users using dos commands ShowManage XP and Vista users using dos commands Enabling or disabling a user Set a password Requiring a user to change password at next logon Specify if the user has the right to change his password Set the minimum length of a password for all...
Personalize web pages with GreaseMonkey ShowPersonalize web pages with GreaseMonkey What is GreaseMonkey? Example 1 Example 2 XPath Utilities removeElement() removeAttributeOfElement() setAttributeOfElement() injectCSS() Links What is GreaseMonkey? GreaseMonkey is an...
Download Caledos Automatic Wallpaper Changer ShowCaledos Automatic Wallpaper Changer, as its name indicates, is a screen background administrator. The main features of Caledos : - it supports the image formats BMP, GIF, JPG, TIF, - easy selection of files or folders, - the possibility of...
Download Yadis! Show
Download LiteIcon Show
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Style classes (CSS) ShowClasses and IDs Classes A web designer might want to assign different styles to the same tags. For this reason, the CSS specifications introduced the concept of classes. The definition of classes is as simple as that of styles. It involves...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Ask your question Reply

1

Excelguru, on Jun 2, 2009 9:33:31 am BST
  • +5

Hi
Use 'conditional formatting' and in that
add one condition with cell background colour as red and the formula =CellAddress<0
add another condition with cell background colour as green and the formula =CellAddress>0
Winners are losers who got up and gave it one more try. -Dennis DeYoung
My Interests are financial Modelling and custom excel development.

   
Reply to Excelguru

2

tinkleberry, on Oct 4, 2009 2:04:03 pm BST
  • +1

Exactly how do you do this? I'm trying to do the same thing but am a Excel noob. Where do I set these conditions and how do I set the condition with the background color change? Thanks.

   
Reply to tinkleberry

3

 Excelguru, on Oct 5, 2009 11:39:37 am BST

Check the link below to study how to do conditional formatting
http://www.contextures.com/xlCondFormat01.html
A wise man once said, 'I complained that I had no shoes unti­l I met a man who had no feet.'
I am interested in financial Modelling and custom excel deve­lopment with excel macros.

   
Reply to Excelguru
Ask your question Reply
They need your help