Percentage comparison between 2 cells

[bill351]

Hi Guys n Girls I am tracking Sick and Overtime in a financial year spreadsheet which is working well in showing the top hours for different staff. I would like if possible to show a percentage comparison with the 2 columns with the Sick and Overtime data in it and with that highlight the staffs name in a separate column and I figured this may be accomplished with Conditional formatting? I have my sick and OT in columns BG and BH and the staff names are in column C and the effect would be if BG1 and BH1 were say within 10% of each other then C1 would be highlighted to indicate that the staff member could be getting Overtime and then taking sick days.

Many thanks from OZ

 

[JumpingCrab]

You can add a conditional format to the staff names in column C: Conditional format>New Rule>use formula

Assuming the first row of data starts in row 2, the formula is

"=ABS($BG2-$BH2)/$BG2<=10%"

Pick any format for the cell.
Then use the format painter to copy the format to all names in column C.

Hope this helps,
JL

 

[bill351]

Hi JumpingCrab that is perfect thank you very much for this solution
Greatly appreciated

Bill from OZ

 

[JumpingCrab]

You're welcome