Use a formula determine which cells to format (C.F New rule function)
in this video I ve told you about conditional formatting
New rule function option (Use a formula to determine which cells to format)
we can apply any formula using this option
a small method mentioned here ,in this video.
My last video lecture about conditional formatting is here Below.