MS Excel / VBA help thread

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

•

Light_EDDed

Morning all.

I’ve got this spread sheet that I use for work. Specifically there is a column for their account value and a separate column for what they should spend in a year based on their spend so far.

What I want to do is conditionally format the company name cell red, yellow or green if they are within a certain percentage of the account value.

I.e.

LFGSS Ltd account value is £1000, but based on their current spend on going to spend £100 in 12 months - company name in red.

Does that make any sense?

•

chez_jay in reply to @Light_EDDed

There's not really enough information here - for example, are the % bands the same for all companies?

I would suggest breaking it down to start with - can you expand your example to describe how you would know the company is Amber if you did it manually, including all relevant factors?

About

Avatar for chez_jay @chez_jay started