|
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 |
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 |
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 |
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 . |
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 . |
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 . |
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 . |
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 . |
| All times are GMT +1. The time now is 12:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com