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,