Nested Functions for Conditional Formatting Formula


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

Advertisements

R

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
 
Ad

Advertisements

M

Mike H

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
 

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