Hi,

Please could any one suggest how to do the following in excel sheet,

I have two numbers in excel spread sheet

1 is target price
and
2 in cost,

Now I would like to show it in RED COLOUR if target price is become
less than cost.

Thanks,

A1 has target price

B1 has cost price

Select A1 then FormatConditional FormattingFormula is:

=A1<B1

Format to red pattern and OK your way out.


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 15:07:15 -0700 (PDT), Nilesh
wrote:

Hi,

Please could any one suggest how to do the following in excel sheet,

I have two numbers in excel spread sheet

1 is target price
and
2 in cost,

Now I would like to show it in RED COLOUR if target price is become
less than cost.

Thanks,

If you have Excel 2007
Assuming Target is in Col A and Cost is in COl B
Select Col A
Choose Conditonal Formatting - Highlight Cell Rules - Less Than
Enter B1 in the text box you get (make sure that there are no $ signs around
B1)
Choose the result you want from the 'With' list

Otherwise do similar thing with Conditional Formatting option in 2003 or
earlier.

"Nilesh" wrote:

Hi,

Please could any one suggest how to do the following in excel sheet,

I have two numbers in excel spread sheet

1 is target price
and
2 in cost,

Now I would like to show it in RED COLOUR if target price is become
less than cost.

Thanks,

Hi Gord,

Thanks very much.

It is working that formula now.

Once again Thanks.

Regards,

Nilesh


On Aug 27, 10:32*am, Gord Dibben <gorddibbATshawDOTca wrote:
A1 has target price

B1 has cost price

Select A1 then *FormatConditional FormattingFormula is:

=A1<B1

Format to red pattern and OK your way out.

Gord Dibben *MS Excel MVP

On Tue, 26 Aug 2008 15:07:15 -0700 (PDT), Nilesh
wrote:



Hi,

Please could any one suggest how to do the following in excel sheet,

I have two numbers in excel spread sheet

1 is target price
and
2 in cost,

Now I would like to show it in RED COLOUR if target price is become
less than cost.

Thanks,- Hide quoted text -

- Show quoted text -