Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have one date field in table
Ex:
03-01-2019
04-01-2019
-------
24-01-2019.
I want display first five dates(03-01-2019 to 07-01-2019) in one color and next two dates (08-01-2019 to 09-01-2019) in one color.
Again next five days(10-01-2019 to 15-01-2019) in one color and next two dates (16-01-2019 to 18-01-2019) in one color.
The above rule for total date field.
Thaks,
Nikil
=if( match( Mod(RowNo(),7), 0,6), rgb(255,0,0), rgb(0,0,255) )
hi
you can do it by using weekday for setting a date color
in your example
in the background example of the font example , you'll use
=if(WeekDay(Date)<>2 and weekday(Date)<>3,green(),red())
will do the trick