A simple problem but I need help please

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-361147%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EA%20simple%20problem%20but%20I%20need%20help%20please%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-361147%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20am%20trying%20to%20build%20a%20spreadsheet%20with%20a%20table%20recording%20monthly%20(rows)%20business%20takings%20by%20year%20(columns)%20that%20will%20apply%20conditional%20formatting%20(red%20and%20green)%20depending%20on%20a%20like%20for%20like%20comparison%20with%20the%20same%20month%20the%20previous%20year.%20Underneath%20each%20cell%20this%20comparison%20will%20also%20be%20represented%20by%202%20further%20cells%20defining%20the%20difference%20between%20the%202%20months%20in%20both%20value%20(pounds)%20and%20percentage%20increase%20or%20loss.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EWhilst%20I%20can%20create%20the%20conditional%20formatting%20for%20the%20first%20part%20for%20a%20single%20cell%2C%20it%20goes%20wrong%20if%20I%20try%20to%20apply%20it%20across%20the%20range%20that%20comprises%20the%20table.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20really%20don't%20want%20to%20manually%20apply%20the%20conditions%20hundreds%20of%20times%20and%20I%20don't%20know%20how%20to%20do%20the%202nd%20bit.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%20please%3F%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-361147%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%20Online%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

I am trying to build a spreadsheet with a table recording monthly (rows) business takings by year (columns) that will apply conditional formatting (red and green) depending on a like for like comparison with the same month the previous year. Underneath each cell this comparison will also be represented by 2 further cells defining the difference between the 2 months in both value (pounds) and percentage increase or loss.

Whilst I can create the conditional formatting for the first part for a single cell, it goes wrong if I try to apply it across the range that comprises the table.

I really don't want to manually apply the conditions hundreds of times and I don't know how to do the 2nd bit.

Can anyone help me please?

1 Reply

@Graham2449 

In the attached file i tried to apply conditional formatting according to your requirement. Is this what you are looking for?