Forum Discussion
Angela_Wilkes
Mar 20, 2020Copper Contributor
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
15 Replies
- SergeiBaklanDiamond Contributor
You may apply conditional formatting rule with the formula which compares values of Minimum Wage Rate with value in Current Rate
- Angela_WilkesCopper Contributor
Hi, thank you for your reply, which formula?SergeiBaklan
- SergeiBaklanDiamond Contributor