Nested Functions for Conditional Formatting Formula

[RandyH]

I'm trying get the right syntax figured out for the following so I can insert
it as a formula for conditional formatting to color a cell red or yellow. Not
sure if an IF function is even the right way to do this since I want the
conditional formatting function to color the cell (not change the contents)
if any of these conditions are true. Here's the basic statement. I need to
be able to place this in the cond formating block. Any help on making this
work would be greatly appreciated.

If B4>8 or (B4>4 and B6>3) or (B4=4 and B6>8) or (B4=3 and B6>8)

 

[Mike H]

Try this

=OR(B4>8,AND(B4>4,B6>3),AND(B4=4,B6>8),AND(B4=3,B6>8))

Mike

 

[RandyH]

Thanks Mike - works perfect for what I was trying to do. I was getting all
wrapped up in the proper way to combine the OR and AND.

You saved me a lot of time and I learned something new!

Thanks again.

Randy

 

[Mike H]

your welcome

Thanks Mike - works perfect for what I was trying to do. I was getting all
wrapped up in the proper way to combine the OR and AND.

You saved me a lot of time and I learned something new!

Thanks again.

Randy