• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

3 CFs in a cell

fortune

Member
D2=value or "" (null)
E2=77 or "" (null)
F2=value or "" (null)

Output required: in B2 with CF to be done in the below priorities
B2=D2 provided D2>0 and E="" and D2>=F2 with CF1: Back ground color1
B2=D2 provided D2>0 and E=77 and D2>=F2 with CF2: Back ground color2
B2=F2 provided E="" and F2>0 with CF3: Back ground color3

Thanks in advance for the help rendered.
 
Back
Top