UDF to flag and color cell

[cchoo13]

Hi,

I have below code to basically check if a selected range of cells are colored, and then Flag "Y" if they are. What I need to do next is to highlight the cell I flag with "Y" with yellow color (colorindex = 6), however I can't seem to make the highlight cell working. How do I do that?

Please Login or Register  to view this content.

[DonkeyOte]

A UDF can only return a value
(ie you can not use a UDF to format a cell).

You would need to use Conditional Formatting to alter the fill colour of those cells containing Y.

[cchoo13]

A UDF can only return a value
(ie you can not use a UDF to format a cell).

You would need to use Conditional Formatting to alter the fill colour of those cells containing Y.

Then is there anyway for me to use macro to do this?
Eg. Range from Column A - E is selected, if any cells from this range has colors, then Column F will be flagged with "Y" and highlighted in Yellow. Conditional Formatting is good however if macro can do this without the additional Conditional Formatting steps, then it would be good.

Thanks.