Conditional formatting 2003 - Highlight cell

Closed

mariamallari Posts 1 Registration date Tuesday September 7, 2010 Status Member Last seen September 7, 2010 - Sep 7, 2010 at 04:34 AM
Trowa - Sep 7, 2010 at 09:10 AM

Hello,

I am looking for ways on how to apply conditional formatting if column B cell value appears to be lesser than column A.

What should be the formula?

Please help !

Thanks,

Conditional formatting 2003 - Highlight cell
Folder highlight - Download - Customization
Apply conditional formatting to the selected cells ✓ - Excel Forum
How to make a close friends highlight public - Instagram Forum
Clear only the formatting from the selected cell (leaving the content) - Guide
Excel conditional formatting if another cell contains specific text - Excel Forum

1 response

Answer 1 / 1

Trowa
Sep 7, 2010 at 09:10 AM

Hi mariamallari,

Use this formula:
=B1<A1

Best regards,
Trowa

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Highlight cell if another cell contains any text

Excel - IF function with multiple words

one cell will turn green when the two other cells match

Similar discussions

Subscribe To Our Newsletter!