Conditional format range if one cell contains certain text [Closed]

Question

Conditional format range if one cell contains certain text [Closed]

Report

Trying2Learn - May 19, 2016 at 03:07 PM
Blocked Profile - May 19, 2016 at 08:01 PM

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!

Excel if cell contains any text
Conditional Formatting range of date cells based on another cell ✓ - Forum - Excel
Conditional formatting range of cells ✓ - Forum - Excel
Conditional formating - apply on more cells ✓ - Forum - Excel
Conditional formatting based on two cells (date and comment) ✓ - Forum - Excel
Conditional formatting based on another cell; apply to rows ✓ - Forum - Excel

1 reply

Ask a question

Blocked Profile · Answer 1 · 2016-05-19T20:01:53-0400

Answer 1 / 1

Blocked Profile
May 19, 2016 at 08:01 PM

Here, check this out!

Have fun!

https://ccm.net/forum/affich-897918-colour-in-spreadsheets-that-are-formulated

Conditional format range if one cell contains certain text [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!