Conditional Formatting Based On Adjacent Fields

Okay I am going to try and explain this.

I have three columns: One Titled RO#, Parts Needed and Parts Picked Up By

The first cell under each column is A3 for RO#, B3 for Parts Needed and C3 for Parts Picked Up By. There is a drop down box in column C that has names.

Basically if A3 and B3 have value (text, numbers) then I want C3 to show red until a name is picked from the drop down. Once they select a name from the drop down list I want the cell to return to it's normal color.

Does that make sense?

Just for fun -- no function calls:

=($A3<>"")*($B3<>"")*($C3="")

Root_ that worked perfectly! I am sorry ChemistB, I couldn't get that formula to work for me.

Glad to have helped.

So I do have another question that maybe more complicated and I am not sure if it can be done.

If the field (C3) hasn't had something filed in within an allotted time frame can the field flash colors. Like if the field hasn't been filed out in 1 second to 5 minutes it flashes green, 5 minutes and 1 second to 10 minutes it flashes yellow, 10 minutes and 1 second and up flashes red?

This is doable but would require VBA programming.

Also, you might want to check this thread.

Way out of my comfort zone lol

Thank you Root_