Jun 21 2021 04:42 AM - edited Jun 21 2021 04:44 AM
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.74 | 33.1 | 16,550.00 |
959.69 | 1,038.70 | 15,580.00 |
70.52 | 75.8 | 9,854.00 |
130.05 | 352.7 | 26,452.00 |
1,334.97 | 1,421.85 | 11,374.00 |
171.96 | 196.9 | 33,473.00 |
286.63 | 268.25 | 13,412.00 |
147.82 | 174.1 | 9,227.00 |
what to do???????
Jun 21 2021 05:07 AM - edited Jun 21 2021 05:40 AM
Here is a small example with conditional formatting
Purchased | Current | Current Value |
Price | Market Price | |
36,74 | 33,10 | 16,550.00 |
959,00 | 1038,00 | 15,580.00 |
70,52 | 75,80 | 9,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.
Jun 21 2021 07:15 AM
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?
Jun 22 2021 11:48 PM
Jun 23 2021 04:39 AM
Solution