Layout disply according to Employee Attendance

[rahulhv1]

I have developed a software for Production manpower management with bar codes. In this, apart from salary details, i used to store attendence details of manpower in a table . In another master table i have machine no. against each of the person.  I want pictorial presentation of the machine layout i.e. if a person is absent. in picture the colour of machine should get red so that the superwiser will note immediately that the machine is idle and he need to have some one else to work on it.

Above piture Shows that manpower for 4 machines is available but for M/C5 Rajesh is absent. this screen should be appeart for superwise for the date he selects. pls. find attachments.

[Nicole-Smith]

See the attached.

This is pretty close to what you want, and by using a table, it will at least be dynamic.

[rahulhv1]

It's working, thank you so much, but how do the colurs get changed of that cell, pls. give steps for that.

[albertovarela · Accepted solution]

You can change the colour of a cell based on a condition or expression. Got to the chart properties > Expression tab, > expand the expression > Background Color...