ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   conditional formatting? (https://www.excelbanter.com/excel-discussion-misc-queries/252980-conditional-formatting.html)

JoAnn

conditional formatting?
 
I have two columns....some of the cells in Column A differ from the cells in
column B...how do I hilight the cells in column A that are different from the
ones in column B? thanks!

Jo

David Biddulph[_2_]

conditional formatting?
 
Either CF/ Cell Value Is/ not equal to/ =B1
Or CF/ Formula Is/ =A1<B1
--
David Biddulph

"Joann" wrote in message
...
I have two columns....some of the cells in Column A differ from the cells
in
column B...how do I hilight the cells in column A that are different from
the
ones in column B? thanks!

Jo





All times are GMT +1. The time now is 07:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com