Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Nested Formulas | New Users to Excel | |||
Conditional formatting/functions | Excel Discussion (Misc queries) | |||
Nested functions in conditional formatting formulae | Excel Discussion (Misc queries) | |||
large formula question - Max nested functions | Excel Worksheet Functions | |||
ENTER EXCEL FORMULA WITH MORE THAN 7 NESTED FUNCTIONS | Excel Worksheet Functions |