Conditional formatting - value of 2 coloumns

Closed
tteerr - Mar 7, 2012 at 08:00 AM
venkat1926 Posts 1863 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?

Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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