Macro for conditional formatting

Hello everyone,

I'm a newbie in the whole Macro world, and I am struggling to find the information to solve my problem.

I have created a Macro to compare data, so the Macro brings up some info from different files and pastes it in the corresponding table. The very last step would be for it to compare cell value from one month to the other and highlight if there is a mismatch between last month's data and this month's.

With conditional formatting is fairly simple, my condition is "=B7 <> Q7", then highlight, for every cell to be compared. (not sure if you need this info but the idea is for the formatting to highlight if there are differences between numbers we entered in previous month's file for latest 12 months vs the info we have on current file)

I'm sorry if any info is missing, I'm very new to all of this.
I highly appreciate your time and help!

Best,
Flor.

Well the most important thing missing is which cell(s) to paint and an example file so we can help write a code exactly to fit your needs.
if it is only limited to one cell then this should work.

Please Login or Register  to view this content.

where you can replace Range by any range of cells link f.e. Range("A3:A20")
The first statement will change the background color to red and the else statement will remove that color again.

This macro will need to be excecuted with button or shortcutkey.
The code could also be places in a eventmacro like Worksheet_change so that it will update automaticly.

when coding there are many ways to get to a simular result and how to resolve is largely based on how the actual file looks