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?

Try something like this in the formula

=OR(AND(CurrentCell<.7,AnotherCell="male"),AND(CurrentCell<.6,AnotherCell="female"))

--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Rosanne" wrote:

> 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?

This worked perfectly. Now, how do I copy this formatting to other cells in
the same column whereby the reference cells in the formula will change
appropriately. When I tried to paste special the formats, it came the same
cell designations.

"Barb Reinhardt" wrote:

> Try something like this in the formula
>
> =OR(AND(CurrentCell<.7,AnotherCell="male"),AND(CurrentCell<.6,AnotherCell="female"))
>
> --
> HTH,
> Barb Reinhardt
>
> If this post was helpful to you, please click YES below.
>
>
>
> "Rosanne" wrote:
>
> > 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?