Conditional Formatting

[dpeped]

Hello,

We have a measure trans/HR by yyyymm looking to conditional format with arrows or colors by comparing the previous trans/hr with the current.

[dpeped]

Everything you have done has worked well, on below how would we order the columns by PPE starting with the oldest PPE first?

[dpeped]

Thank you. We would also like provide a summary count of how many indiviuals increased their production and how many decreased.

[ryan_mayu]

@dpeped 

pls see the attachment below

[ryan_mayu]

could you pls provide some sample data and expected output?

[dpeped]

Thank you it worked, a couple tweaks we are struggling with is counting the number of individuals who increased or decrease their production, also we are trying to break the month into pay periods. Thank you.

[ryan_mayu]

you are welcome

[dpeped]

How we would change the yyyym to a pay period in other to make the logic work every two weeks and not monthly.

[ryan_mayu]

pls update your sample data and expected output

[dpeped]

Thank you.

[ryan_mayu]

@dpeped 

should the red arrow for Rob be blank? 

What's more , I didn't see any decrease in your sample data. Why you got 1 and 2?

[dpeped]

That was just to give an example of what we are trying to do not only show the increase decrease by person by pay period but also a summary count of how many increase or decreased their production by pay period.

[ryan_mayu]

so based on the sample data on the left side, what's the correct output on the right side?

[dpeped]

[ryan_mayu · Accepted solution]

pls see the attachment below