Nested Functions for Conditional Formatting Formula
 

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 B48 or (B44 and B63) or (B4=4 and B68) or (B4=3 and B68)

Nested Functions for Conditional Formatting Formula
 

Try this

=OR(B48,AND(B44,B63),AND(B4=4,B68),AND(B4=3,B6 8))

Mike

"RandyH" wrote:

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 B48 or (B44 and B63) or (B4=4 and B68) or (B4=3 and B68)

Nested Functions for Conditional Formatting Formula
 

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" wrote:

Try this

=OR(B48,AND(B44,B63),AND(B4=4,B68),AND(B4=3,B6 8))

Mike

"RandyH" wrote:

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 B48 or (B44 and B63) or (B4=4 and B68) or (B4=3 and B68)

Nested Functions for Conditional Formatting Formula
 

your welcome

"RandyH" wrote:

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" wrote:

Try this

=OR(B48,AND(B44,B63),AND(B4=4,B68),AND(B4=3,B6 8))

Mike

"RandyH" wrote:

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 B48 or (B44 and B63) or (B4=4 and B68) or (B4=3 and B68)