Have a question on how to do a custom formula in conditional format for the following:
Column A1 = DCC220.....Column B1 = 7.50.....Column C1 = 7.00.....Column D1 = 7.60
I want to compare the result in B1 (7.50) to a range, C1 lower, D1 upper, but only if the value in A1 is DCC222. Color green if B1 is in the range of C1 and D1 and red if it is not.
Any help, thanks