ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Conditional Formatting (https://www.excelbanter.com/excel-worksheet-functions/147071-conditional-formatting.html)

nabanco

Conditional Formatting
 
Hello,

Is there a way to set conditional formatting into a column that would turn a
cell red if the word "Float" appears?

I see where you can choose to format based on values or formulas, but not
specific words.

Thank you

Mike H

Conditional Formatting
 
Try,

Cell value is|Equal to|="Float"

Mike

"nabanco" wrote:

Hello,

Is there a way to set conditional formatting into a column that would turn a
cell red if the word "Float" appears?

I see where you can choose to format based on values or formulas, but not
specific words.

Thank you


nabanco

Conditional Formatting
 
Thank you Mike once again.

"Mike H" wrote:

Try,

Cell value is|Equal to|="Float"

Mike

"nabanco" wrote:

Hello,

Is there a way to set conditional formatting into a column that would turn a
cell red if the word "Float" appears?

I see where you can choose to format based on values or formulas, but not
specific words.

Thank you



All times are GMT +1. The time now is 10:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com