Conditional formatting - value of 2 coloumns

Closed
tteerr - Mar 7, 2012 at 08:00 AM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Mar 8, 2012 at 01:47 AM
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

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Mar 8, 2012 at 01:47 AM
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
0