Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Usiing a formula to Conditional Format XL2007
Hi all,
I'm trying to use the following formula to format a single row if any of the cells ($AD$149 or $AL$149 or $AS$149 or $AZ$149) is equal to or greater than the target cell ($M$149) =OR($AD$149=$M$149,$AL$149=$M$149,$AS$149=$M$14 9,$AZ$149=$M$149) All comments/pointers welcomed. -- Steve Efficiency is intelligent laziness. - Anonymous |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Usiing a formula to Conditional Format XL2007
Are you getting a message in the CF when you try to enter that formula?
Just reverse the operators. Instead of using = use =. =OR($AD$149=$M$149,$AL$149=$M$149,$AS$149=$M$14 9,$AZ$149=$M$149) That will apply the formatting if M149 is an empty cell and any of the other cells are also empty. Do you need to account for that possibility? If so, you can add another test that M149 is not empty/blank. =AND($M$149<"",OR(............)) -- Biff Microsoft Excel MVP "Steve" wrote in message ... Hi all, I'm trying to use the following formula to format a single row if any of the cells ($AD$149 or $AL$149 or $AS$149 or $AZ$149) is equal to or greater than the target cell ($M$149) =OR($AD$149=$M$149,$AL$149=$M$149,$AS$149=$M$14 9,$AZ$149=$M$149) All comments/pointers welcomed. -- Steve Efficiency is intelligent laziness. - Anonymous |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting on a Row - XL2007 | New Users to Excel | |||
Conditional Formats XL2007 | Excel Discussion (Misc queries) | |||
Conditional Formatting in XL2007 | Excel Worksheet Functions | |||
Conditional formatting different on XL2007 than XL2003 | Excel Discussion (Misc queries) | |||
return a cell contents as the result of usiing "small" | Excel Worksheet Functions |