SOLVED

excel

New Contributor

for example i have two columns with names Current Market Price & Purchased Price. Now what i need is if the cell value in Current Market Price column is LESS than cell value in Purchased Price column automatically in the third Column i.e. Current value cell must turn automatically into red color .

 

Purchased
Price
Current
Market Price
Current Value

36.7433.116,550.00
959.691,038.7015,580.00
70.5275.89,854.00
130.05352.726,452.00
1,334.971,421.8511,374.00
171.96196.933,473.00
286.63268.2513,412.00
147.82174.19,227.00

 

 

what to do???????

8 Replies

@19901807 

Here is a small example with conditional formatting

PurchasedCurrentCurrent Value
PriceMarket Price
36,7433,1016,550.00
959,001038,0015,580.00
70,5275,809,854.00

 

Hope I could help you with this information.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

@19901807 

You may use rule with formula

image.png

applied to

image.png

@Sergei Baklan 

 

Sir,

 

Thank you for the reply .

 

but if i try to apply this conditional formatting all the cells are turning to red as per your instruction.

 

what to do?

@19901807 

Could you please provide sample file or at least screenshot similar to above? Without them it's hard to say why it doesn't work in your case.

@Sergei Baklan 

 

Sir,

 

Please find the attached file .

best response confirmed by allyreckerman (Microsoft)
Solution

@19901807 

Please find the file with applied rule attached.

Thank you very much for the help

@19901807 , you are welcome