Color Code a Result

[ppcbuilders]

I would like to have a pct change formula that compares the values of two cells show up in green if the pct change is positive and in red if the pct change is negative.

Any help would be appreciated.

[etaf]

how are you comparing the two cells

Assuming comparisons are in B1 and B2
and the result in A1

so whats the % you are comparing

the difference

so (B1-B2)/B1

si if +ve then Green
if -ve then Red

you could use conditional format and use a formulas in conditional format

A1 < 0 then red
A1> 0 then green

what colour do you want if 0 ?

[protonLeah]

with starting value in A1 and ending value in B1, put:
In C1: =IF(A2="",0,(B2-A2)/A2)

With C1 selected,
1. Click Conditional Formatting, click Highlight cell rules, click "Greater than" and choose the desired color.
2. Click Conditional Formatting, click Highlight cell rules, click "Less than" and choose the desired color.

[noboffinme]

Hi ppcbuilders,

Do you mean you have 2 Columns with percentage numbers & you want to compare the change in value of the percentages in the same Row?

If so, have a look at the attached file.