Hi.
My intention would be to use conditional formatting with the new rule. If any value (integer) in the selected range changes, then a particular cell outside the range turns red. This would be an indicator to me that after editing the table I would remember to run the macro.
I can do it for one selected cell but I don't get the formula for this correctly.
Johnny
Last edited by johnny100; 05-26-2020 at 03:55 PM. Reason: Solved with VBA
what range is changing
what range is fixed that you want to change
can you perhaps provide a sample - see yellow banner
with saple data and an example of what has changed and colour the corresponding range as the cond frmt would do
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks