please advise the solution

[Nilesh]

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,

 

[Gord Dibben]

A1 has target price

B1 has cost price

Select A1 then Format>Conditional Formatting>Formula is:

=A1<B1

Format to red pattern and OK your way out.


Gord Dibben MS Excel MVP

 

[Sheeloo]

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]

Hi Gord,

Thanks very much.

It is working that formula now.

Once again Thanks.

Regards,

Nilesh