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 -