conditional formatting with two conditions

[RachelW78]

Good Day,

I am trying to apply conditional formatting to cell K. IF cell C is greater than or equal to cell N and cell K equals ENTERED I need the cell in column K to be highlighted. I have made many attempts and read just about everything I could find on-line and in the Excel Bible. Originally I was thinking the IF(AND) nested statement however that only caused error codes and through reading went to the AND statement. I tried just using an AND statement (as both conditions are TRUE), no errors but no results either. Any advise on how to get this accomplished?

 

[RachelW78]

here is the link, please help why this is not working. I deleted out any critical data. <a href=http://www.filedropper.com/postedmrexcel><img src=http://www.filedropper.com/download_button.png width=127 height=145 border=0/></a><br /><div style=font-size:9px;font-family:Arial, Helvetica, sans-serif;width:127px;font-color:#44a854;> <a href=http://www.filedropper.com >file upload storage</a></div>

 

[Marcílio_Lobão]

RaquelW78, Good afternoon.

I don't know why at you computer the formula is not working.

Using your file I did:

Select K2:K2759

Conditional Format Menu --> Using Formula -->

=AND(C2>=N2, L2="ENTERED")

Chose Format Fill color as GREEN
OK
---> 103 cells become GREEN

Please, do the same thing and tell us if it's working for you now.
I hope it helps.

 

[RachelW78]

i tried it the way you suggested above and no results. I then did the same thing in just cell K2 and they copy/pasted formatting only and that worked. I really, really appreciate your assistance!!

 

[BQardi]

=AND(C1>=N1;L1="Entered") tried that too it does not seem to take

Where are you from?
In some countries, conditions in formulas are separated with a comma ",".
In other countries, with semicolon ";"
Have you taken this into account?

=AND(C1>=N1[COLOR="#FF0000"][B];[/B][/COLOR]L1="Entered")

=AND(C1>=N1[COLOR="#FF0000"][B],[/B][/COLOR]L1="Entered")

Just a thought. Please disregard if you are aware of this issue...

 

[Marcílio_Lobão]

RachelW78, Good evening.

I used your file and followed the instruction Step by Step.

It worked as desired.

http://www.filedropper.com/postedmrexcel--ok

I hope it helps.

 

[dancingducks29]

I am also having a similar issue, I have tried the things above and many other things to no avail.

I want to Highlight a whole row if the text value in column D is yes AND the text value in Column E is Yes

Most things that I've tried said something like
=AND($D1="Yes",$E1="Yes"

That does not work.

What am I doing wrong?

Thanks in Advance!

 

[Marcílio_Lobão]

dancingducks29, Good evening.

It's not a good idea to use a very old post to post a new question.
Remember this next time!

Your issue:

Your formula is Correct.

Select rows you want: ROW 2 thru ROW 10

Conditional Format Menu --> Using formulas -->

Type: =AND($D1="Yes",$E1="Yes")

Choose FILL color as desired --> OK

Each time on a row from 2 to 10 both cells Column D and Column E are YES, entire row will be colored.

Is that what you want?

I hope it helps.