Create formulas in conditional formatting

R

Rosanne

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

Barb Reinhardt

Try something like this in the formula

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

Rosanne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top