Forum Discussion

Angela_Wilkes's avatar
Angela_Wilkes
Copper Contributor
Mar 20, 2020

Help to create a formula

Hi I am trying to create a formula that tells me that I need to change the rate of pay for someone when they reach a new age category. I have a column and formula to create the exact age (17years, 3 months, 5 days), these cells update automatically. I have one column with the employees current wage rate and another column with the set minimum wage for that employees age range.

I would like the Minimum Wage Rate to change colour when it falls below the employees current rate of pay column.

Thank you

Resources