Question Conditional Formatting

[bursteffect]

Hey every body, I hope your day is going better than mines. I am working on a project that determines how many times a employee is late, and i want to use conditional formatting to display the amount of times listed. for example( Carl Williams was late on 3/4/15) so my report shows that violation and in my report his name is highlighted in yellow. The next time his name is highlighted in orange, then red, once red he receives a warning letter, and so on. I've never really fooled with conditional formatting before and would like some imput if you can.

 

[Minty]

Ideally You will need to include a count of late times in the query for the form, and then use this to conditionally format either the whole row or a text box.

 

[bursteffect]

So just making sure, i will have to add a field that i can place in the table for instance " count " and when that person is late I put a "1" in that field, and the next time 2, 3 and so on. Then use conditional format like "[count] = 1, is yellow, [count]=2 are orange and so forth? I was hoping that i could be able to use unconditional formatting based on a duplicate value. but anyway i cant alwasy get what i want.

Thank you.

 

[CJ_London]

conditional formatting is pretty straight forward - the main thing to do is get the order right for example

>1 is yellow
>3 is orange
>5 is red

wont work because the first condition is met first every time - you need to put in the reverse order

>5 is red
>3 is orange
>1 is yellow

Also reference the count - you refer to first and second time - so if your report is say a list of attendances where Carl Williams appears multiple times - and on the 3/4/15 he was late (so yellow), then he wasn't late again until 3/8/15 (so orange), you will need a more complex solution than a simple count

 

[bursteffect]

thanks for the quick response, ill try something new