please advise the solution

  • Thread starter Thread starter Nilesh
  • Start date Start date
N

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,
 
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
 
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.
 
Hi Gord,

Thanks very much.

It is working that formula now.

Once again Thanks.

Regards,

Nilesh
 
Back
Top