Font Color

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered

Hi-

I'm creating a report with Actual expenses and Plan expenses. I would like to change the font color if it's Plan expenses and leave actual expenses with the black color. In addition, I would like this only to impact this specific report.

Thank you!

Allie

Photo of Alexandra Loiselle

Alexandra Loiselle

  • 70 Points

Posted 1 year ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 12,348 Points 10k badge 2x thumb
Hi Alexandra,

The option to highlight records in a report using a formula specific to that report colorizes the entire row itself, it doesn't change the color of the font. Alternatively, if you want to colorize the font you have to create a formula rich text field that will take the field where you input the expenses manually (or they are calculated by another formula) and convert it into a colorized font based on whether it is an Actual Expense or Planned Expense. Then once you have that field created and the formula put in you would build your report based on those new fields to get colorized font. It sounds like the row colorization might be an easier option for you if you want to confine it to one report. The linked help topic below covers how to apply row colorization:

https://help.quickbase.com/user-assistance/row_colorization.html

 Do you use a multiple choice field or a checkbox to differentiate between Actual Expenses and Planned Expenses?
(Edited)