MS Excel / VBA help thread

You are reading a single comment by @SomethingOrOther and its replies. Click here to read the full conversation.

•

NotThamesWater in reply to @SomethingOrOther

As Sam_w says, conditional formatting.

Please don't colour any other columns though. I may get project PTSD.

•

SomethingOrOther in reply to @NotThamesWater

I have no use for the colour I however have an MD who likes red/green and he both pays me monthly and hopefully pays my bonus so red/green it is.

•

NotThamesWater in reply to @SomethingOrOther

If you want over-engineered, overly-coloured tracking spreadsheets, then I'm your man.

Nested if statements within conditional formatting, on cells that are nested if statements, to decide if the tick or cross should be green, red or yellow.

About

Avatar for SomethingOrOther @SomethingOrOther started