Excel formula help please.

[Tony Towner's Fridge]

I have forgotten how to change the background colour of a cell depending on the cell contents

I want it Red=Planned
Green=Completed

grey matter waning I'm afraid..

Any help anyone?

ta

TNBA

TTF

 

[KingstonSeagull]

vlookup

VLookups tend to slow down your processing speed.

I use index match

 

[KingstonSeagull]

I have forgotten how to change the background colour of a cell depending on the cell contents

I want it Red=Planned
Green=Completed

grey matter waning I'm afraid..

Any help anyone?

ta

TNBA

TTF

You need to use conditional formatting in the home tab and enter your conditions.

 

[Tony Towner's Fridge]

Bingo....many thanks KS.

TNBA

TTF

 

[CherryInHove]

SUMIF

=SUMIF(A1:A999, "Wickes", B1:B999)

Column A has your company names, column B the amounts. No matter how many you add onto the list later, the function will still work (up to 999 rows obviously)

If you might have more than 999, you can just do:

=SUMIF(A:A, "Wickes", B:B)

Although, what I'd do is:

Copy column A to Column D. Select column D, Data -> Remove Duplicates, then Column D will just have each one listed once.

Then in E1 put =SUMIF(A:A,D2,B:B) and copy that down.