Hi, me again
I am doing conditional formatting on a cell which shows a percentage from a simple calculation
B136 is a maximum score possible, F142 is a target %age rate (currently 88%) and C136 is the actual score achieved.Please Login or Register to view this content.
I want to attribute C136 GREEN if the actual score (C136) is >= the evaluated %age score and RED is < the evaluated %age score
I'm trying to fit in the ROUNDUP expression with for no decimal places but failing miserably.
My problem is when the truncated actual score is nearly at the 88% rate but actial value is fractionally less as in
because the %age is actually 87.98646 so the cell highlights with a RED fill rather than a GREENHTML Code:
How do I include the ROUNDUP function to no decimal places in my conditional formatting expression?
thaaksPlease Login or Register to view this content.
Bookmarks