Can anyone help me to create the formula please? If it is possible, then I would like to link the AVG results to a 2nd sheet to show a chart. but I am not sure this is available via using a formula because each result is a lighter shade of a main colour, the main colour being the one used for the average.Ĭan anyone please help me know if Excel can handle a formula for the way I input the data to create an AVG automatically. I have a colour code range that reflects the SYSTOLIC result only (that's the high number of the two ref. Occasionally I am too busy and 'miss' a test.

The data collected up to now covers almost 12 months - so there is a lot. Unfortunately I am not very good when it comes to working out a formula for such data. I came across this thread BP Excel Formula and have tried to change what I think should be changed but since I have a 'LEFT', a 'MIDDLE' and a 'RIGHT' number along with the '/' & '-' x 3 for each test, I cannot work out how to alter it to work. plus additional data, I want to keep to this format so that I can easily input and see ALL data I input on a screen without left/right scrolling (not spread out over multiple columns for individual numbers taking up too much width with all the additional data - which I know now would make it so much easier to do, but I do not have time now to reset all the data). The format I use in each column for the digital testing machine's results is S/D-H (85/70-81).īecause this is a standard way of showing these 3 measurements and because with a total of 6 measurements a day. Each time I take 3 tests and then manually AVG.

Blood pressure readings chart excel