Code to identify whether a cell has manual highlighting or not

[Dave K]

Hello - i am trying to generate the
word "yes" if the cell to the left of it contains any highlighting at
all.

99% of the cells that i am trying to flag contain yellow
highlighting, fyi.

So, for example, the result in Cell I2 will display "yes" if cell H2
has any highlighting, and so forth down the column.

Or another option would be for me to find some code that simply allows
me to sort a column (i.e., column H) by whether the cells have
highlighting or not.

Thanks for any suggestions, or workarounds that may produce the same
outcome.

 

[GS]

How about a change of approach? Instead of manually highlighting H2,
enter "Yes" in I2 and set ConditionalFormatting for H2 to highlight if
I2="Yes".

 

[Gord Dibben]

You didn't like the answer you got earlier from me?

I told you where to find some code.

Did you go look?


Gord Dibben MS Excel MVP

 

[GS]

Gord,
I didn't mean to butt in. I just realized (by your comments) that this
topic (or very similar) was also posted in another NG.

 

[Dave K]

You didn't like the answer you got earlier from me?

I told you where to find some code.

Did you go look?

Gord Dibben     MS Excel MVP

Yes....got it. Thanks Gord. Was having trouble opening the .BAS file.
Then realized the function was in the webpage as well.

Thanks again!

 

[Gord Dibben]

Good to hear.

For future........................

You don't "open" the *.bas file.

You Import it into your workbook.

Store the *.bas file in a folder then open VB Editor.

Right-click on any module in your workbook and "import file"

Browse to the folder where *.bas is stored and d-click to import as a module.


Gord