Need either Formula or Macro for below case :
If "CONFIRM" is entered in Column A, then Column D and E should get highlighted in color (any color will do as long as it attracts the attention of the user).
Once either Column D or E gets updated with any data the color should go away.
In case of Formula -
Explanation would be helpful
In case of Macro -
Since we are using multiple sheets (around 12 sheets) need a common macro for all sheets.
Have attached a plain excel sheet. Use the same for your formula or macro