Conditional format range if one cell contains certain text
Closed
Hello,
I'm looking to use conditional formatting to make the cell next to a particular recurring word (for example, "new") highlighted. I have a series to tables in my spreadsheet that sort automatically and all contain the same titles, but each with different numerical values. I've set the sheet up so that one word in the set will always highlight automatically, but I would like the numerical value in the cell next to it to also be highlighted. Not sure what formula would do this since the numbers are always changing.
Does anyone know how to do this? Very grateful!
I'm looking to use conditional formatting to make the cell next to a particular recurring word (for example, "new") highlighted. I have a series to tables in my spreadsheet that sort automatically and all contain the same titles, but each with different numerical values. I've set the sheet up so that one word in the set will always highlight automatically, but I would like the numerical value in the cell next to it to also be highlighted. Not sure what formula would do this since the numbers are always changing.
Does anyone know how to do this? Very grateful!
Related:
- Conditional format range if one cell contains certain text
- Format factory - Download - Other
- Kingston format utility - Download - Storage
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Marksheet format in excel - Guide
- Excel date format dd.mm.yyyy - Guide
1 response
Here, check this out!
Have fun!
https://ccm.net/forum/affich-897918-colour-in-spreadsheets-that-are-formulated
Have fun!
https://ccm.net/forum/affich-897918-colour-in-spreadsheets-that-are-formulated