Hi Luke
I had already done that, I now realise my error though, it was due to setting the type to percentage rather than formula, as my cell is a formula stating the movements between two other values
Thanks
Paul
Hi guys
I am wanting to try and use conditional formatting in excel relating to KPI's. I am trying to use the icon set to show variances in KPI's such as trade debtor days for example, which may be positive, there may be no movement, or it may be negative.
For positive I am wanting a green...
Hi guys
Any help would be gratefully accepted! I am trying to write VB code to hide my rows depending upon the value entered into a cell. There will be a value entered into a cell in my excel sheet (the value will be a whole number 1,2,3 or 4) then depending upon this value I will want to...