ExcelBanter - check for highlite and text

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - check for highlite and text (https://www.excelbanter.com/excel-worksheet-functions/210599-check-highlite-text.html)

bricer

check for highlite and text

If I have a cell that is highlited and has a text value, is there a function
or formula that I can to check for that instance?

Sheeloo[_3_]

check for highlite and text

Use the Edit|Find option... and pick the value and format in the dialog box...

I am using Excel 2007 but I think the same option was available in Excel
2003 also.

"bricer" wrote:

If I have a cell that is highlited and has a text value, is there a function
or formula that I can to check for that instance?

bricer

check for highlite and text

I'm sorry, I was not clear. I am trying to add cell in a range that have a
value of "X" and are highlited red.

"Sheeloo" wrote:

Use the Edit|Find option... and pick the value and format in the dialog box...

I am using Excel 2007 but I think the same option was available in Excel
2003 also.

"bricer" wrote:

If I have a cell that is highlited and has a text value, is there a function
or formula that I can to check for that instance?

All times are GMT +1. The time now is 02:52 PM.