@MacIDScot1981
Because they did not describe your project exactly what you want exactly.
Change cell color when value changes, cell color fixed if you want to keep track
of which page the data comes from, or, or..many ors can be.
At the same time there is no information about which Excel version and operating system it is.
Therefore I am sending you this link with general information
about Microsoft Conditional Formatting.
Use conditional formatting to highlight information
https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60...
Hope I could help you with that.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
