Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if one cell greater than another cell, how to change colors?
For example:
I have an amount allotted: $900,000. Amount used exceeds amount limit. How do I set it so that when the amount used is input and exceeds the amount allotted, it will change colors? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
if one cell greater than another cell, how to change colors?
hi
use conditional formating. you didn't say how your data is layed out so... if amt allotted is in column A and amt used is entered in column B then in cell B1.... formatconditional format.... If cell value is......greater than.......=$A$1......Pick your color. copy down column B - paste special - formats only Regards FSt1 "OS05" wrote: For example: I have an amount allotted: $900,000. Amount used exceeds amount limit. How do I set it so that when the amount used is input and exceeds the amount allotted, it will change colors? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
if one cell greater than another cell, how to change colors?
I have the allotted amount in one cell above the rest, then the amounts used
are broken down by days of the week below the allotted amount. I understand that I probably have to format each cell, but would it still work in this situation? "FSt1" wrote: hi use conditional formating. you didn't say how your data is layed out so... if amt allotted is in column A and amt used is entered in column B then in cell B1.... formatconditional format.... If cell value is......greater than.......=$A$1......Pick your color. copy down column B - paste special - formats only Regards FSt1 "OS05" wrote: For example: I have an amount allotted: $900,000. Amount used exceeds amount limit. How do I set it so that when the amount used is input and exceeds the amount allotted, it will change colors? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
if one cell greater than another cell, how to change colors?
hi again,
yes. but i would assume that you have a "total used" cell. I would put the conditional formating in that cell and ignore the daily entries unless the daily entries are in the habit of exceding the total allocated cell. There is no one correct way to do this. you want to know when you are over budget and where and want a flag to pop up when that happens. so just use the example i gave you..... if total used cell......is greater than..... total allocated cell....pick your color. Put the conditional formating in the total used cell. Regards FSt1 "OS05" wrote: I have the allotted amount in one cell above the rest, then the amounts used are broken down by days of the week below the allotted amount. I understand that I probably have to format each cell, but would it still work in this situation? "FSt1" wrote: hi use conditional formating. you didn't say how your data is layed out so... if amt allotted is in column A and amt used is entered in column B then in cell B1.... formatconditional format.... If cell value is......greater than.......=$A$1......Pick your color. copy down column B - paste special - formats only Regards FSt1 "OS05" wrote: For example: I have an amount allotted: $900,000. Amount used exceeds amount limit. How do I set it so that when the amount used is input and exceeds the amount allotted, it will change colors? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change cell colors for 2 seconds | New Users to Excel | |||
How to have row color change based on one cell to 4 colors | Excel Discussion (Misc queries) | |||
change cell value greater than another cell value using formulas | Excel Worksheet Functions | |||
If a cell is a certain word I would like it to change colors. | Excel Discussion (Misc queries) | |||
CELL & TEXT COLORS DO NOT CHANGE ON MY PC MONITOR | Excel Discussion (Misc queries) |