Basic NOOB VBA question (Conditional Formating)

[Leadparsons]

I all,

out of all the code I have written in to my DB and had help on I seem to have hit a basic one that I can not sort.

I have two fields 1 and 2, I want to put conditional formatting on no 2 to highlight (in green) if no 1 is the same as no 2 or if not the same highlight (in red).

I now it has something to do with IIF but I can only get that to work on one field if it is true.

Help, my brain seems to have turned to mush.

 

[Joe4]

I now it has something to do with IIF but I can only get that to work on one field if it is true.

Did you Conditionally Format BOTH fields using your formula?

Can you post your formula?

 

[Leadparsons]

IIF([Cell1],[Cell2],true)
Im not sure how to write it, im only Conditionally Formatting on one field.

 

[Joe4]

For equal, your Conditional Formula would just be:

=[Cell1]=[Cell2]

For not equal, your Conditional Formula would just be:

=[Cell1]<>[Cell2]

If you need more help than that, list all the actual details of an example (what your cell addresses are, what the values are, etc).

 

[Leadparsons]

I am working in Access ! It does not accept the code.

Field 1 is called IA_Value field 2 is called LOI_Amount, so if the two match I want field 2 to be highlighted.

 

[Leadparsons]

Managed to do it, not by using the expression by stating the field value is = to

 

[Joe4]

I am working in Access ! It does not accept the code.

Whoops, I confused my Access and Excel. Sorry about that. With the gap in time between replies, I forgot where I was.

Glad you got it figured out.