Changing a cell colour if target not met.

[brett.good]

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?

 

[OssieMac]

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.

 

[brett.good]

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?

 

[brett.good]

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








- 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.

 

[brett.good]

Doesn't Matter.

Figured it out. Thanks.