Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing a cell colour if target not met.
Hi All,
I am trying to work on a spreadsheet that will allow a cell to change colour if the right dollar amount is not entered by the current multipying formula I have in it. For example.... I currently have a spreadsheet where I calculate somebodies hours by multiplying there hours cell by using a figure in another cell..... so basically =(s1*t4), so what I want to do is have that cell change to Green in $900.00 is met or remain Red if less than $900 is entered. Can anybody help me? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing a cell colour if target not met.
Conditional Format will do what you want. If you can't follow the Help
instructions then post your version of Excel so that step by step instructions to get you started can be given. -- Regards, OssieMac " wrote: Hi All, I am trying to work on a spreadsheet that will allow a cell to change colour if the right dollar amount is not entered by the current multipying formula I have in it. For example.... I currently have a spreadsheet where I calculate somebodies hours by multiplying there hours cell by using a figure in another cell..... so basically =(s1*t4), so what I want to do is have that cell change to Green in $900.00 is met or remain Red if less than $900 is entered. Can anybody help me? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing a cell colour if target not met.
On Apr 27, 12:42*pm, wrote:
Hi All, I am trying to work on a spreadsheet that will allow a cell to change colour if the right dollar amount is not entered by the current multipying formula I have in it. For example.... I currently have a spreadsheet where I calculate somebodies hours by multiplying there hours cell by using a figure in another cell..... so basically =(s1*t4), so what I want to do is have that cell change to Green in $900.00 is met or remain Red if less than $900 is entered. Can anybody help me? Hello? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing a cell colour if target not met.
On Apr 27, 12:56*pm, OssieMac
wrote: Conditional Format will do what you want. If you can't follow the Help instructions then post your version of Excel so that step by step instructions to get you started can be given. -- Regards, OssieMac " wrote: Hi All, I am trying to work on a spreadsheet that will allow a cell to change colour if the right dollar amount is not entered by the current multipying formula I have in it. For example.... I currently have a spreadsheet where I calculate somebodies hours by multiplying there hours cell by using a figure in another cell..... so basically =(s1*t4), so what I want to do is have that cell change to Green in $900.00 is met or remain Red if less than $900 is entered. Can anybody help me?- Hide quoted text - - Show quoted text - Microsft Office Excel 2003 - (11.5612.5606) Part of Microsoft Standard Edition. I'm hopeless with Excel, I commenced courses 2 weeks ago and I've only got the basics down so far. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing a cell colour if target not met.
Doesn't Matter.
Figured it out. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing background colour when changing data in a cell | Excel Discussion (Misc queries) | |||
Changing a cell colour | Excel Discussion (Misc queries) | |||
VBA / Changing the colour of cell given an input | Excel Programming | |||
Changing colour of text in cell | Excel Programming | |||
Changing Cell Colour | Excel Programming |