Background Color - macro

[mukky]

Hello,

i need help with thisVBA script

These need to insert a macro, which will be checked [temperature Papers] back color, and if so red field box [evaluation] turns red and insert it into the text "NOK"


I tried these scripts, but it did not work

If Me.[teplota prac].BackColor = RGB(237, 28, 36) Then
Me.[zhodnotenie].BackColor = RGB(237, 28, 36)
Else
Me.[zhodnotenie].BackColor = vbWhite

here is picture

thanksss

 

[PNGBill]

Does [teplota prac] need to be [teplota_prac] ?

Can you ' out the lines except Me.[zhodnotenie].BackColor = RGB(237, 28, 36)

This will test if your colour code works and it is just the If Then statement that needs attention.