I'm trying to create a report that colors a row red if a date field has a date past 9 days
I'm trying to create a report that colors a row red if a date field has a date past 9 days - If ([Date Released for Inspection]> days+(9) ,"red","")
Forum Discussion
John, you will find that red is too hard to read though.
There is a great tool here out up by another great QuickBase solution provide, Laura Hillier. https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=1
so instead of where you have red, you would put in the hex code like #E55451
There is a great tool here out up by another great QuickBase solution provide, Laura Hillier. https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=1
so instead of where you have red, you would put in the hex code like #E55451
- I like "pink", its a soft red that translates well to reports.
- Thanks... the color was not so much the answer I need. I need the formula to make that happen when the dated released for inspection is past 9 days.
Thank you - Very useful color selection tool - thanks Mark!
- Thx Laura :)
- Thanks... the color was not so much the answer I need. I need the formula to make that happen when the dated released for inspection is past 9 days.
Thank you
