Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a column which is Concatenation of ID & Month. The requirement is
ID |
123-Apr |
213-May |
312-June |
765 |
987 |
764 |
So the requirement here is
The month less than Today = should be always shown as Yellow ( irrespective of selected or Not selected)
Future months Should always shown as Light green (Not selected field in Light Green)
the selected Field(Future) ID should be shown as dark Green
the selected ID&month(COMPLETED MONTH) ID it should Always shown in Yellow
Can anyone help with this please
the light green/dark green requirements are a bit confusing to me. in any case, you can use the Text colour expression section.
if(YOURmonth<month(today()),rgb(250, 250, 120) , and so on .