You are reading a single comment by @Light_EDDed and its replies.
Click here to read the full conversation.
-
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?
-
It definitely sounds like it should be easy enough (assuming there is consistency in what you want to do).
Usual caveats of are you sure that colouring stuff in is the best solution. You might want some helper columns (e.g. the percentage) to make the formula easier and, more importantly, let you use formulas for analysis and look at things in more detail if required.
chez_jay
aggi
@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?