Search : in
By :

Changing cell colour through % differnce

Last answer on May 21, 2009 7:35:25 am BST ginga ninja, on May 20, 2009 10:09:02 am BST 
 Report this message to moderators

Hello,

Im trying to create a formula, were by if the differnce between two cells is greater than 30%, i want the beginning cell to change colour.

For example : G5 is greater than H5 by 45%, so A5 needs to be highlighted (fill cell with colour/or font colour change)


Been trying to do it for hours now, can anyone help ?? :(

Configuration: Windows XP Internet Explorer 7.0

Best answers for « changing cell colour through % differnce » in :
How to change the colour of the menu? Show
Excel: If date >= 30 days, cell change color (Solved) Show
[Excel]changing cell formula to text Show [Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
MS-DOS Window - How to change the appearance? ShowMS-DOS Window - How to change the appearance? Option Tab Font Tab Layout Tab Colors Tab When you open a window command prompt, it is possible to change this window (size and color). You can also change the cursor shape and other...
Using the [su] command ShowUsing the ‘‘su’’ command The ''su'' Sign in as a different user ID with "su" Start a new shell connection with "su -" Back to previous shell Notes The ''su'' The "su" is defined as the "Super User" which has the ability to...
Download Change Folder Icons ShowAs its name suggests, Change Folder Icons will allow you to search and replace quickly the standard icon of a folder or disk. Easy to use, simply press the right button of the mouse on a folder by selecting the item “Change Folder Icon”. The icons...
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...
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...
Using FTP commands ShowThe FTP protocol FTP (File Transfer Protocol) is a protocol — meaning a standard language that lets two machines communicate — used so that computers of different types (or with different operating systems) can transfer files over a...
Backgrounds ShowAdding a Background Image A background image for a web page can be set using the tag: Attribute Visual Effect BACKGROUND="image" Displays image as background bgcolor="name_of_Colour or #XXXXXX" Displays the given colour...
Ask your question Reply

1

Excelguru, on May 20, 2009 12:34:04 pm BST

Hi

Do conditional formatting
Select A5 select ' conditional formatting from Format menu
use the formula =g5-H5>0.45

Give the format you need

Do let me know If it helps... 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

 mubashir aziz, on May 21, 2009 7:35:25 am BST

Try this in conditional formatting box .........

=(G5-H5)/H5>0.45



Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran

   
Reply to mubashir aziz
Ask your question Reply
They need your help