[not so serious] Excel conditional formatting?

Not quite sure where this belongs, since it isn't really a VBA question... my goal is simple - I'm translating bits of text on a web page, using resource files, and right now, what I need translated doesn't match what I have. So, I'm making a nice spreadsheet that breaks apart everything- three columns, field name, English, and French. All I want is to highlight any rows that have English text, but not French. Should be simple, but the formula syntax just doesn't want to work with me.. any help would be great :afrog:

EDIT: Ok, just got fired. Don't need this anymore... commence the CC'ing?

Somebody please make fun of me here!

I'm sorry but I don't twit.

Quote:

---

EDIT: Ok, just got fired. Don't need this anymore... commence the CC'ing?

---

50 minutes later:

Quote:

---

Somebody please make fun of me here!

---

Do you still need it?

This should be in Office Development forum.

* Highlight the range, say "A2:C50", with "A2" is ActiveCell.
* In Conditional Formatting box, select Formula Is :
* Enter formula: =AND($A2<>"",$B2<>"",$C2="")
* Click Format and set hightlight color as you want.

Ahhh.... I was mis-using the AND command. That makes sense now. Thank you, kind sir.

You don't sound too gutted about losing your job, TS.

He really doesn't need a job. He was just working for fun.

Quote:

---

Somebody please make fun of me here!

---

I'd mock you but the challenge is gone.

Quote:

---

Originally Posted by wossname

You don't sound too gutted about losing your job, TS.

---

I'd rather prefer a learning timeshifter than an emo timeshifter, TYVM.

They were ripping me off left and right... $38k/year for .Net 3.5, C#, AJAX-driven web applications... nobody in this area pays that little. This just gives me a chance to try and kick off my freelance work. Hopefully it'll be enough...