add color cells in a table

[RimDataAnalyst]

Hello, I want to add a background color expression in a table here are the conditions:

• red  : 12 month  before  initial period end date ( if end en decembre 2023 so red january  2023)
• All the line on color grey if termination different than 12/3000

and this is what I put:

for the first condition: 

IF(date([contracting_signature.Termination Date],'M/D/YYYY') <= date(12/01/3000, 'M/D/YYYY'),'#CCCCCC')

 for the second condition :

IF(date([contracting_signature.Initial period end Date])='-' or year([contracting_signature.Initial period end Date])> YEAR(Today()) or [contracting_signature.Initial period end Date]='','#FF0000')

[ogster1974]

use a valid colour code like RGB() ARGB(),HSL() or Qlik Colour codes like Black(), Red() etc...

https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/Colors/color-by-expr...