no, i am not looking to color individual cells, the whole row is fine. I just can't figure out what the formula should be to make this happen.
so something like this:
if to QC "date populate" = yellow
if returned from QC "date populate" = blue
if to QC 2 "date populate" = green
If returned from QC 2nd "date populated = Red
something like that?
I had
If(
[To QC 1]<(Today()+Days(1)), "yellow",
[Returned QC 1]>(Today()+Days(1)), "blue")
but when i got to the second line, is does not read the 2nd next statement.
I also tried
If( not IsNull([To QC 1]),"yellow",
If( not IsNull([returned QC 1]),"blue"))
but it only reads the "TO QC 1" statement, ignoring the first line.
I know i am likely missing something basic, but again newbie! :)
------------------------------
Bret Osborne
------------------------------
Original Message:
Sent: 11-14-2022 11:18
From: Mark Shnier (Your Quickbase Coach)
Subject: Color Coding Dates
If you are looking to colour code individual cells as opposed to rose on a table report then it is not quite as easy as conditional formatting is, in excel. You need to create a new Rich Text formula field.
https://helpv2.quickbase.com/hc/en-us/articles/4570255561108-Color-coding-fields
When you do this however that field will no longer be a date field and you will not be able to use dynamic filters as easily.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 11-14-2022 09:30
From: Bret Osborne
Subject: Color Coding Dates
I am newer to QB, but have found formulas to be a challenge so far.
I am trying to do simple color coding for dates, for example i have 4 columns of dates, that will be populated through the project. As each progression of the project is complete i would like to have that date color coded to show the "stage".
so column A,B,C,D, then i will select colors for each column. If no dates are populated, then it would not be color coded. I believe this should be some type of IF statement, but not sure how to formulate it. Thank you for your help!
------------------------------
Bret Osborne
------------------------------