Conditional formatting - value of 2 coloumns

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I have 2 coloumns mith qty bal and min value. i would lile a condition were IF the qty bal is less than the min value, the min value cell is highlighted in colour.

Can this be done please?

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
suppose the qtybal is in A1
min value is in B1
then select B1
in conditional formatting
the formula is
=A1<B1
click format
click pattern
choose color
click ok
click ok