hi,

I've searched as mush as possible (google etc), but maybe my search terms aren't accurate enough

anyway I have 400+ cells that I am looking to apply conditional formatting to

Unfortunately I'm looking to use the icon set formatting (traffic lights)
and because of this, relative referencing is not allowed - the format will be applied based on the current cells value in relation to another cell in the worksheet
so for each cell I need to apply the conditional formatting individually

I've tried recording a macro whilst doing this, but the macro does not capture anything.

Does anyone have any code snippets that I could use, to loop through these cells and apply the formatting?

Thanks

Mitch