Coloring different "cells" rows and columns

[Kev_1988]

Hi,

I want give different colors in my tbltestoverview "cells". How can I give the "cells" own color? What is the best way to do it?

I've created a table with a different columns like column: test1, test2 and test3. I've given the "cells" random numbers like 1, 2 or 3 for each columns

1 stands for: Blue color
2 "" red color
3 "" yellow color

So I created another table for "tblcolorlevel"
with first column "colorID" autonumber second column "colorlevel" short text
Under column colorID you have a row 1, 2 and 3
Under column colorlevel you have blue, red and yellow
So basically 1 = blue
2 = red
3 = yellow

I know how to connect the source tblcolorlevel with tbltestoverview
But the point is how can I give blue --> color blue and red --> color red and so on?
What vba code can i use for it?

Or is there any easier way to give table "cells" colors?

Note: i'm a beginner in access and vba user. So please be patient with me
Thanks for understanding

Please help me with this

 

[plog]

tables are about data--period. Think of them as just space on a computer disk--you get to control nothing except the actual data.

What you want to achieve would be best done in a Report. In that you can set fonts, text color, background color, borders, etc.. Check out this link for that:

https://support.office.com/en-us/ar...67a-8240-ee6e01597291?ui=en-US&rs=en-US&ad=US

 

[Kev_1988]

Oke thanks, I will look at that as well later on.
For now I've found a solution like use conditional formatting.

tables are about data--period. Think of them as just space on a computer disk--you get to control nothing except the actual data.

What you want to achieve would be best done in a Report. In that you can set fonts, text color, background color, borders, etc.. Check out this link for that:

https://support.office.com/en-us/ar...67a-8240-ee6e01597291?ui=en-US&rs=en-US&ad=US