highlight column A if column A does not equal to B

G

Gord Dibben

Select a range in column A and Format>Conditional Formatting>Formula is:
=$B1<>$A1

Format to a color and OK.


Gord Dibben MS Excel MVP
 
G

Gord Dibben

Format>Conditional Formatting>Cell Value is: equal to 0

Format to a color and OK


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two columns followed by single page-width column on same page 0
Need Help with a VBA subroutine 0
Highlight every 5th recurrence in a column for a given value/id 1
Cobditional Formatting Rows based on dates in action plan. 0
Copy addition formula of non-consecutive horizontal cells 2
How to center adjust text above and image in a two column document. 1
AppleScript - How do I select a text ? 1
Font drop-down menu very slow 0

Top