|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to conditionally format cells in Col. A if it matches adjacent cell in Col. B?
Column A lists actual recorded amounts (numerical values) and Column B lists estimated amounts (also numerical values).
How can I highlight cells in Column A if the value does not match the value in its adjacent cell in Column B? |
#2
|
|||
|
|||
Select the cells in A.
Select Home: Conditional Formatting: New Rule... Select a Rule Type: Format only cells that contain Edit the Rule Description: Format only cells with: Cell Value - not equal to - [select the top value in the column] The address will be something like =$B$1. Delete the $ absolute reference designators so it looks like =B1. Set your format. Click OK. See attached sample file. |
#3
|
|||
|
|||
Thank you!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to conditionally format this? | g4tv4life | Excel | 2 | 03-13-2014 10:58 AM |
How to modify the figures and cell format in multiple cells at once? | officeboy09 | Excel | 5 | 01-16-2014 07:41 PM |
Word Macro to find and delete rows that contain adjacent cells containing "." | AlexanderJohnWilley | Word VBA | 7 | 11-08-2012 10:15 AM |
How to merge two columns & replace contents of cells conditionally? | mag | Excel | 3 | 10-24-2012 01:07 PM |
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell | Frogggg | Excel | 1 | 10-25-2011 08:44 PM |