Color Coding Formula Help
In our app we have a date field titled "Initial ISD". I am trying to write a formula that will turn all records with an "Initial ISD" that is 30 days or less from today's date the color red. Any help is greatly appreciated!
Forum Discussion
7 Replies
- Here is an example of a row colorization formula for a table report type
IF(Today()-[Initial ISD] < Days(30), "pink") // but the pink is pretty wimpy.
you can also use "red" but its so strong a color that it blots out the words.
You can also use hex codes. There is a list of them here from Laura another QSP.
https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=1
IF(Today()-[Initial ISD] < Days(30), "#F665AB") // this is a decent pink. - This is perfect, thank you!
- If I wanted to add another set of conditions to this such as "if it is less than 15 days, then green", how would I add that?
- IF(
Today()-[Initial ISD] < Days(15), "#00FF00") // green.
Today()-[Initial ISD] < Days(30), "#F665AB") // this is a decent pink. - Thank you!
- I am getting an error on the "Today" on the third line. It states "There are extra characters beyond the end of the formula"?
- Never mind, I believe I have it figured out. Thank you again!
