Conditional formatting - value of 2 coloumns
Closed
tteerr
-
Mar 7, 2012 at 08:00 AM
venkat1926
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Conditional formatting - value of 2 coloumns
- Excel conditional formatting 2 color scale formula ✓ - Forum - Excel
- Conditional formatting if cell does not contain specific text ✓ - Forum - Excel
- Conditional formatting if another cell contains any text ✓ - Forum - Excel
- Copy conditional formatting from one row to another ✓ - Forum - Excel
- If cell contains date then conditional format - Guide
1 reply
venkat1926
Mar 8, 2012 at 01:47 AM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
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
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
