Nested Functions for Conditional Formatting Formula

  • Thread starter Thread starter RandyH
  • Start date Start date
R

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

RandyH said:
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
Click to expand...
 
Back
Top