Conditional formating

Hi folks,

I'm swapping excel to access, however, I'm facing some problems.

 In excel I used to use the following formulas for conditional formating:

1 -  " =$a1<>$a2 " then put a line border.

2 - " =a$1='sales order' " then highlight the whole row.

Does anyone know how to do the same in access?

Thanks
samuel maiaSage Co-ordinatorAsked:
Who is Participating?
 
Gustav BrockCIOCommented:
In Access, you can set the format field by field only.

So, select a field, open Conditional Formatting.
Then choose "Field value is", Equals (or Not Equals), NameOfOtherField
Finally, select the format to apply.

cf.PNG
0
 
Gustav BrockCIOCommented:
Answer provided.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.