April 22nd, 2010, 12:43 PM
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
.
|