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?

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?

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?

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.

Changing a cell colour if target not met.
 

Doesn't Matter.

Figured it out. Thanks.