Recent content by Eileen

I thought I had in your sample :- and mine vdet1 is the 1st condition vdet 2 is the 2nd. I have done a work around for the time being in that condition 1 is now on A and condition 2 is on B but I would like to have them both on A-B eventually. In the meantime it runs !

What I should have said on the same fields I have requirement for 2 conditional formats One colour if ah > 0 and the other colour if e is greater than d. They will never be both at the same time.

Thanks for the help so far, but I am still struggling with this. Can anyone spot a stupid mistake as I am getting and error on 1 line when I run this. /* lcnt = line counter. mcnt is column count colname is M N O P etc.*/ vdet1 = "= " + colname[mcnt - 2] + STRING(lcnt) + "...

Unfortunately I don't think so That allow you to set an icon against a cell what I need is to colour fill the celldepending on 2 formula. In excel under cond. formatting add in formatting via rules manager I just cant see how to convert the Macro lines above to progress lines as the syntax...

Can anyone assist me . I am trying to add conditional formatting into a spreadsheet from progress. I have recorded the macro in excel to see if I can work out the progress lines. I need to change the background colour depending on 2 formula. So to set cell B3 to colour 34 if ah3 > 0 or to...