Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
550
using conditional formatting to comare cell value with its previous value
posted

I need to compare a cell value with its new value and accordingly change its background to green if cell new value is higher else to red if cells new value is smaller. i also want a upward/ downward arrow besides it.

 

can you help me with this requirement. should i use conditional formatting or valueconvertor?

how to go about it?