Vba to change cell colors and highlight rows
Closed
Childishact
Posts
1
Registration date
Friday October 23, 2015
Status
Member
Last seen
October 23, 2015
-
Oct 23, 2015 at 05:35 PM
mikkelsheeto Posts 1 Registration date Wednesday June 1, 2016 Status Member Last seen June 1, 2016 - Jun 1, 2016 at 10:19 AM
mikkelsheeto Posts 1 Registration date Wednesday June 1, 2016 Status Member Last seen June 1, 2016 - Jun 1, 2016 at 10:19 AM
Related:
- Vba to change cell colors and highlight rows
- Vba case like - Guide
- Number to words in excel without vba - Guide
- Change computer name cmd - Guide
- Notepad++ change background color - Guide
- How to change idm language - Guide
2 responses
Welcome to the show! HEHE!
It is called "conditional Formatting". You set a logic statement, then a "Format".
See here:https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f?ui=en-us&rs=en-us&ad=us
Have fun.
It is called "conditional Formatting". You set a logic statement, then a "Format".
See here:https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f?ui=en-us&rs=en-us&ad=us
Have fun.
mikkelsheeto
Posts
1
Registration date
Wednesday June 1, 2016
Status
Member
Last seen
June 1, 2016
Jun 1, 2016 at 10:19 AM
Jun 1, 2016 at 10:19 AM
If you're using Excel 2016 and looking to do this, check out our second tip in our tutorial: [REMOVED] called "Highlight cells that contains text". This will make you achieve exactly what you're looking for :) Let me know if it causes any trouble and I'd be happy to help out!
