FormatRangeX doesn't enable dd/mm/yyy Date format

[Udiar (Udi Or)]

Hi,
I’m trying to use FormatRangeX to change the font color of an excel cell, in dd/mm/yyyy Date format, but the activity doesn’t allow such format (instead, it allows mm/dd/yyyy Date format).

Please advise, how can I overcome this?

Thanks

[supermanPunch (Arpan)]

@Udiar

to change the font color of an excel cell, in dd/mm/yyy Date format,

Hi @Udiar ,

I believe you could specify a custom format by Selecting the Format as Custom and specifying the format as dd/MM/yyyy.

For the Font color, you can select the Font tab and select the color rquired.

[Yoichi]

Hi,

Can you try dd/mm/yyyy with Custom as the following?

Regards,

[Udiar (Udi Or)]

Thank you both, your solution works very well !!!