Forum Discussion
Conditional Formatting for 2 columns (one is text, one is date/time)
Hi, I was looking into the forum and was unsure if this question was answered yet. I am attempting to do conditional formatting myself, however I have not been able to achieve the desired results. I would like to potentially highlight either a cell or the entire row (which would be the better option) by background color with an IF statement. Essentially, IF the Status = 'In Process' AND Due Date = past due (so < TODAY() maybe?), that entire row is highlighted red and whoever is looking at it, knows to pay attention to the item. In theory, the rows of ID 66574 & 89541 would be red. Here's a snapshot of the table:
3 Replies
PadycosmosSolution Sage
Hope this video helps:
I believe that this solves only the 1st part of my problem. Is there a way to add an AND in the formula somewhere to color based on two column values instead of one?
- Padycosmos
You can try something like this:
Colour = SWITCH(TRUE(),SELECTEDVALUE([Status])="Released"&& [Past Due] < Today()),"Pink",
