Conditional Formatting

[scotball]

I have a table

Rows = Person
Columns = Weeks

The cells will contain percentages to track week on week performance per person.

I would like to fill the cells, green if Week 2 is higher than week 1 and red if week 2 is lower than week 1 then replicate this for the other weeks and other people.

Help please

LP

 

[Trevor G]

Do you mean something like this:

Excel Workbook
	A	B	C
1	Peeps	Week 1	Week 2
2	John	0.05%	0.60%
3	Bill	0.09%	0.01%
4	Jack	2.50%	2.50%
5	Sarah	1.66%	1.77%
6	Anne	0.98%	0.96%
Sheet1

Two formula in the Conditional Formatting

=(C1>B1) Then Red

=(B1>C1) Then Green

Perhaps it might help if you show some data.