Conditional Formatting:

[tatendatiffany]

I need a conditional format for if column A and AC and not match (so comparing each cell i.e A2 amd AC2, A5 and AC5) if they are matching i want it to be a green if not matching red. but the formula iahd used wont work.

 

[JamesW]

Hi,

Highlight column A and goto Format -> Conditional Formatting, then enter:

Formula Is:

=A1=AC1 for Green
=A1<>AC1 for Red

 

[tatendatiffany]

Thank you very much that solved to problem just like that (and i had been struggling with it for hours)

Thank you

Can i also ask another quick question (about loops and sql ) if you have any knowledge in that area??

 

[JamesW]

You are probably best starting a new thread.

For SQL queries (Access related) post here: http://www.mrexcel.com/forum/forumdisplay.php?f=18