IF ? function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greeneyez2 - 17 Aug 2006 23:38 GMT

I need to subtract one cell from another and if the sum is 3000 or over, I
want the cell to be red. I need a function to do this. I'm a newbie so please
if you answer give me the complete function.
Thank you,

Reply to this Message

Franz Verga - 17 Aug 2006 23:46 GMT

> I need to subtract one cell from another and if the sum is 3000 or
> over, I want the cell to be red. I need a function to do this. I'm a
> newbie so please if you answer give me the complete function.
> Thank you,

You can use Conditional Formatting.

Select the cell with your sum then from menu Format, Conditional Formatting,
under Condition 1 select "Value is" tehn in the next drop down select "upper
or equal" then type 3000 in the text box. Click on Format, select the format
you prefer then click OK twice. And the job is done...

Signature

(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Reply to this Message

Bob Phillips - 17 Aug 2006 23:48 GMT

You need conditional formatting on that sum. Change the condition in CF to
formula is, and use a formula of

=$A$1-$B$1>=3000

and set the colour to red

See http://www.contextures.com/xlCondFormat01.html

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> I need to subtract one cell from another and if the sum is 3000 or over, I
> want the cell to be red. I need a function to do this. I'm a newbie so please
> if you answer give me the complete function.
> Thank you,

Reply to this Message