I have a dynamic excel sheet snapped to streaming quotes which are displayed on column C. I have my target range Column G-D. Have already applied color format to Column G-D , which will be highlighted when the quotes of Column C enters range of Column G-D. And it works. But since the quotes are dynamic as soon as the number changes or goes below the range, the highlight also goes away. Is there a way where once we get the range highlighted (when conditions are met) , it remains highlighted irrespective of the change in original condition i.e price change in Column C.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional formating
- Thread starter sharestar
- Start date
