LinkBack URL
About LinkBacks
Hi,
I need to check Columns B to F with Columns I to M and if there is difference highlight both the cell. Can anyone help me to find a solution.
Regards,
Hi,
I need to check Columns B to F with Columns I to M and if there is difference highlight both the cell. Can anyone help me to find a solution.
Regards,
You can use Conditional Formatting with two rules
Conditional Formatting
- Highlight applicable range >> $B$9:$F$116
- Home Tab >> Styles >> Conditional Formatting >> New Rule
- Select a Rule Type: Use a formula to determine which cells to format
- Edit the Rule Description: Format values where this formula is true: =B9<>I9
- Format… [Number, Font, Border, Fill] Select Fill >> Red
- OK >> OK
- Highlight applicable range >> $I$9:$M$116
- Home Tab >> Styles >> Conditional Formatting >> New Rule
- Select a Rule Type: Use a formula to determine which cells to format
- Edit the Rule Description: Format values where this formula is true: =I9<>B9
- Format… [Number, Font, Border, Fill] Select Fill >> Red
- OK >> OK
Last edited by jeffreybrown; 05-29-2017 at 08:56 AM.
HTH
Regards, Jeff
Hi,
thanks, the data provided is just a sample, the original data exceeds more than 10 k. I would prefer a vba solution.
Try...
Please Login or Register to view this content.
Last edited by jeffreybrown; 05-29-2017 at 10:24 AM.
jeffreybrown,
Thanks for the code, I will check and get back to you tomorrow. I am out of office.
Last edited by jeffreybrown; 05-29-2017 at 11:06 AM. Reason: Removed full quote as it's just clutter
Thanks Jeffrey, I have checked the code and it's exactly what I expected.
You are very welcome. Happy to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks