| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional more than one iif
I need to conditional format based on if two cells are evaluated:
If in this row the value in column U is = 1 and the value in column M is 30 then row should be highlighted green I probably should not wait til the end of the day to start a new excel sheet...lol Joe |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional more than one iif
Hi,
Try this CF formula =AND($U1=1,$M1=30) Select the full row before you apply it, change the 1 to the row you are in. -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "JoeM" wrote: I need to conditional format based on if two cells are evaluated: If in this row the value in column U is = 1 and the value in column M is 30 then row should be highlighted green I probably should not wait til the end of the day to start a new excel sheet...lol Joe |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional more than one iif
No IF needed
Let's say you want this to apply to rows 2 thru 20 Select the row headers 2:20 so that the entire range is highlighted For you Conditional Format formula use =AND($M230,$U2=1) We reference cells in row 2 here because that this the first row of our selected range Note that the formula used in conditional formatting generally should return TRUE or FALSE BTW: why in your question did you but 1 and 30 in quotes. We seldom need quotes around numbers in Excel best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "JoeM" wrote in message ... I need to conditional format based on if two cells are evaluated: If in this row the value in column U is = 1 and the value in column M is 30 then row should be highlighted green I probably should not wait til the end of the day to start a new excel sheet...lol Joe |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional more than one iif
I tried the both above but to no avail.
I want to select all the rows and if a value in column M are greater than 54 (54) and the value in column V is = 1 then highlight the row. Joe "Bernard Liengme" wrote: No IF needed Let's say you want this to apply to rows 2 thru 20 Select the row headers 2:20 so that the entire range is highlighted For you Conditional Format formula use =AND($M230,$U2=1) We reference cells in row 2 here because that this the first row of our selected range Note that the formula used in conditional formatting generally should return TRUE or FALSE BTW: why in your question did you but 1 and 30 in quotes. We seldom need quotes around numbers in Excel best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "JoeM" wrote in message ... I need to conditional format based on if two cells are evaluated: If in this row the value in column U is = 1 and the value in column M is 30 then row should be highlighted green I probably should not wait til the end of the day to start a new excel sheet...lol Joe . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional more than one iif
BTW: why in your question did you but 1 and 30 in quotes. We seldom need
quotes around numbers in Excel No particular reaason just wantd to note the values I was looking for, probably some of MSAccess queries rubbing off on me, long day, sorry! Joe "Bernard Liengme" wrote: No IF needed Let's say you want this to apply to rows 2 thru 20 Select the row headers 2:20 so that the entire range is highlighted For you Conditional Format formula use =AND($M230,$U2=1) We reference cells in row 2 here because that this the first row of our selected range Note that the formula used in conditional formatting generally should return TRUE or FALSE BTW: why in your question did you but 1 and 30 in quotes. We seldom need quotes around numbers in Excel best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "JoeM" wrote in message ... I need to conditional format based on if two cells are evaluated: If in this row the value in column U is = 1 and the value in column M is 30 then row should be highlighted green I probably should not wait til the end of the day to start a new excel sheet...lol Joe . |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional more than one iif
I tried the both above but to no avail.
Both solutions are the same and if you have described your problem correctly both work. If you select a range of rows then the number in the formula must be the top row number of the selected range -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "JoeM" wrote: I tried the both above but to no avail. I want to select all the rows and if a value in column M are greater than 54 (54) and the value in column V is = 1 then highlight the row. Joe "Bernard Liengme" wrote: No IF needed Let's say you want this to apply to rows 2 thru 20 Select the row headers 2:20 so that the entire range is highlighted For you Conditional Format formula use =AND($M230,$U2=1) We reference cells in row 2 here because that this the first row of our selected range Note that the formula used in conditional formatting generally should return TRUE or FALSE BTW: why in your question did you but 1 and 30 in quotes. We seldom need quotes around numbers in Excel best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "JoeM" wrote in message ... I need to conditional format based on if two cells are evaluated: If in this row the value in column U is = 1 and the value in column M is 30 then row should be highlighted green I probably should not wait til the end of the day to start a new excel sheet...lol Joe . |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional more than one iif
Maybe it's my CF formula?:
=AND($U1=1,$M130) "JoeM" wrote: BTW: why in your question did you but 1 and 30 in quotes. We seldom need quotes around numbers in Excel No particular reaason just wantd to note the values I was looking for, probably some of MSAccess queries rubbing off on me, long day, sorry! Joe "Bernard Liengme" wrote: No IF needed Let's say you want this to apply to rows 2 thru 20 Select the row headers 2:20 so that the entire range is highlighted For you Conditional Format formula use =AND($M230,$U2=1) We reference cells in row 2 here because that this the first row of our selected range Note that the formula used in conditional formatting generally should return TRUE or FALSE BTW: why in your question did you but 1 and 30 in quotes. We seldom need quotes around numbers in Excel best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "JoeM" wrote in message ... I need to conditional format based on if two cells are evaluated: If in this row the value in column U is = 1 and the value in column M is 30 then row should be highlighted green I probably should not wait til the end of the day to start a new excel sheet...lol Joe . |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional more than one iif
The formula works fine, but what i am finding out is if I start my sheet at
say A45 the formula doesn't seem to get the same results, where if I start the sheet at A1 it works fine. Joe "JoeM" wrote: Maybe it's my CF formula?: =AND($U1=1,$M130) "JoeM" wrote: BTW: why in your question did you but 1 and 30 in quotes. We seldom need quotes around numbers in Excel No particular reaason just wantd to note the values I was looking for, probably some of MSAccess queries rubbing off on me, long day, sorry! Joe "Bernard Liengme" wrote: No IF needed Let's say you want this to apply to rows 2 thru 20 Select the row headers 2:20 so that the entire range is highlighted For you Conditional Format formula use =AND($M230,$U2=1) We reference cells in row 2 here because that this the first row of our selected range Note that the formula used in conditional formatting generally should return TRUE or FALSE BTW: why in your question did you but 1 and 30 in quotes. We seldom need quotes around numbers in Excel best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "JoeM" wrote in message ... I need to conditional format based on if two cells are evaluated: If in this row the value in column U is = 1 and the value in column M is 30 then row should be highlighted green I probably should not wait til the end of the day to start a new excel sheet...lol Joe . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
| Conditional Rank (or rather, Conditional Range) | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
![JoeM[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
