Recent content by Adam

Our Hosted UC solution based on Mitel would be a good choice. https://www.talktalkbusiness.co.uk/products/voice/business-phone-systems/hosted-voice/ Can use physical Mitel IP Phones, softphones etc etc Comes with a centralised corporate directory out of the box, or you can upload your AD...

Spotted the Cliosport sticker on a book in the boot 👍

No. Couldn’t get this working unfortunately Sent from my iPhone using Tapatalk

No I did the CF using “Format only cells that contain” and then “Cell Value” with a less than and more than rule. I’ll look at trying to use the formula options as per your instructions. In terms of the 0 or null, cells in column BC are bringing over a number populated elsewhere within the...

Ok will take a look tomorrow Thanks Sent from my iPhone using Tapatalk

Ok, so I have setup some basic conditional formatting rules as per the below picture The aim of the CF is to highlight a cell in red in column BF if the value is greater or less than what's in column BC - this works fine What I want to do is where yo can see red cells in column BF with a...

Thanks I'll have a look Sent from my iPhone using Tapatalk

Ok :) Well for example, say I want to highlight cells A1:A3 if I've selected or just even by moving over any other cell in row 1 with the cell selector. Then the same for row 2, 3, 4, etc I was just thinking to have cells x1:x3 highlighted by using a red think border or something similar...

Yes the cells could be empty or populated. It's more of a visual thing so when I am in any cell on a given row, three cells of my choosing (within the same row) would be highlight. I'm guessing it's not something that can be done using CF, maybe a VB code which is beyond me haha Sent from my...

Is that not just based on what's in that cell. I can do that no problem. I want it to work when you just select a cell or navigate around cells using the keyboard if that makes sense Sent from my iPhone using Tapatalk

Is it possible to have it so say for example I highlight any cell on a row, certain cells are highlight on the same row. Sent from my iPhone using Tapatalk

Cheers mate, will give it a go :)

What's going to be the easiest way to get the columns populated with the site name and code that changes each time?

Thanks mate, appreciated. Think I need to get my head around it first haha :)

No, Lancaster is done in the example above, what I need is for the ones below Lancaster starting with Medway, so it would be... -- 375 - Medway (which already exists on the sheet) --- 375 - Medway - Survey/WIC Install (new row needed) --- 375 - Medway - Survey Results Uploaded (new row needed)...