Color coding formula

Question

Hi,I'm trying to color code a report depending on a couple different fields. My formula isn't working, but i'm not sure what i'm missing. Any help would be great.Field 1: [All info task] :  we want the record to be pink if it has a date. Field 2: [internal due date] : we want the record to be pink if it doesn't have a dateHere's my formulaif(not isnull([all info task]) or [internal due date]= isnull, "#ff66ff"))
------------------------------Catelyn Atkinson------------------------------

MarkShnierYou · Accepted Answer

OK,try thisIF(not IsNull([all info task]) or IsNull([internal due date]), "#ff66ff")------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

MarkShnierYou · Answer

np,
but I can only correct the portion of the formula that was posted as i can't copy and paste code from an image.
I assume that the field [all info task] is a text field type.

IF(Trim([all info task]) ="" or IsNull([internal due date]), "#ff66ff")

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community