Jump to content

Font size and justification changes in conditionally formatted cells.

Recommended Posts

  • Newbies


I'm hoping someone from 360Works will have seen this issue before and can help. I can ask Microsoft for help as well but I figure you're the best place to start - and I don't have a ton of time to figure this out.

I have a FileMaker solution with a script in which Scribe loads an excel workbook, and writes values. This excel workbook has a bunch of conditional formatting. The first three rows are static, but the rest is conditionally formatted, based on the value of the cell in a hidden column, changing depending on the row.

The problem is that everything after row three is supposed to be size 11 font, and everything but column A is supposed to be centered. Everything in the template itself seems fine, but when I run the script and open the workbook, I find that most cells have changed to size 12 font and left justified (well, right justified after converting all the cells to numbers). It's odd though because scattered about, I see some that are centered and some that are size 11, with no apparent pattern.

Have you seen something like this before? This is for a client who would like to run her FileMaker reports within the next week or two so I'm really hoping this can be resolved and I don't have to tell her to just correct all the formatting herself. So your help would be greatly appreciated!

Thank you!

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.