Hi all,

I need help to write a java program to create a empty excel file and set the first column with formular using COUNTIF.

For example, after file is created, open excel file, and type any string into the rows of the first column.

If there are two rows contains the same strings, then set color with red.

So the excel file with formular I need create by java program, after created, I just let people to enter information into the first column.