Conditional formatting code please

I have run out of conditonal formatting rules in my spreadsheet and I just need one more that I imagine will need to be coded.......

If cell H1 is greater than 1 then colour G1 purple (or thereabouts)

Can someone help please before I have to shell out for a 2007 licence

Many thanks

Hi Cath,

You can actually have four criteria in that if you shade the relevant range in the colour you want (purple) as the fourth (last) criteria, then this colour will be returned (defaulted) if the first three criteria aren't met.

Beyond this, have a look at this code.

HTH

Robert

Hi Cath,

Any cell can have a conditional format that is reliant on the value from any another cell. Have a look at the attached screen shot where this conditional format will work on any cell based on the value in B1.

You really only need to use code if you have more than four formats.

HTH

Robert