Conditional Formatting - Compare Column with previous Column

[TicklyTigger]

Hi,

I have a table where I want to compare the latest values with the values in previous column. I want to show increases in numbers with a green background and decreasing numbers with a red background.

Since I will be continuously adding columns, I was hoping that as I add columns I can just copy and paste the style from previous columns to apply to new columns.

Any idea how to do that with a formula and conditional formatting? See attachment for example data.

Many thanks,

TT

[FDibbins]

Try this...
1. highlight the range you want to apply the conditional formatting to (in your sample =$C$3:$C$13)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter ==C3>B3 format fillGREEN

repeat 3 and 4 for RED
you may need to choose what you do with 0 and no change?

[Jonmo1]

Try like this

Highlight C3:E13
Conditional Formatting - New Rule - Use Formula..
=C3>B3 (set format as Green)
=C3<B3 (set format as Red)


These should automatically expand when you add data to column F

[TicklyTigger]

Super, that worked like a charm! Many thanks!