Previous Topic Next Topic

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,




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?
Leanne99 -
Mooseman -

26 responses
Ig stories from close friends to public
Darren -
zara -

31 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
SKU011.CAB
nina -
Rajkumar -

159 responses