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