I want to create two types of conditional format (red font versus blue font)
if the following conditions apply.

Blue font if (the current cell <.7 AND another cell = "male") OR (if the
current cell < .6 AND another cell ' "female)

Red font (if the current cell 1.3 AND another cell = "male") OR (if the
current cell 1.0 and another cell = "female")

What should the formulas look like?