Use conditional formatting to highlighting cells based on Name
Closed
Kirk_92
Posts
1
Registration date
Tuesday October 24, 2017
Status
Member
Last seen
October 24, 2017
-
Updated on Oct 24, 2017 at 07:44 AM
Blocked Profile - Oct 24, 2017 at 04:44 PM
Blocked Profile - Oct 24, 2017 at 04:44 PM
Related:
- Use conditional formatting to highlighting cells based on Name
- Why can't i see someone's highlights on instagram - Instagram Forum
- How to make close friends highlights public - Instagram Forum
- Excel macro to create new sheet based on value in cells - Guide
- Based on the values in cells b77 ✓ - Excel Forum
- Clear only the formatting from the selected cell (leaving the content) - Guide
1 response
OK so build the CONDITIONAL FORMULA to look for those business.
Take a look here:
https://ccm.net/forum/affich-910435-conditional-formating-formula-cell-text-change-color
The formula will say something like:
=if(cell_to_check="Business 1") {and format it with green}
=if(cell_to_check="Business 2") {and format it with red}
You can have multiple formulas for whole ranges if you wish.
Let us know if you get stuck!
It's kind of fun to do the impossible! -Walter Elias Disney
Take a look here:
https://ccm.net/forum/affich-910435-conditional-formating-formula-cell-text-change-color
The formula will say something like:
=if(cell_to_check="Business 1") {and format it with green}
=if(cell_to_check="Business 2") {and format it with red}
You can have multiple formulas for whole ranges if you wish.
Let us know if you get stuck!
It's kind of fun to do the impossible! -Walter Elias Disney
