Hello all, I’ve received a request to highlight a ...
# generalo
Ondina Sturges
10/19/2023, 4:06 PMHello all, I’ve received a request to highlight a saved search cell when the value is blank so the user quickly see action is required. What’s the trick to highlight a saved search column value without adding a separate Formula HTML column? The column in question is a Custom List and ideally would remain as inline. I know I can add another column with CASE WHEN and formatting.
t
Tim Chapman
10/19/2023, 4:17 PMI didn't know you could highlight one individual cell. I thought it was a whole row or nothing. I'll have to look
Tim Chapman
10/19/2023, 4:21 PMYou can use a Formula(html)/ Formula(numeric) for highlighting purposes only?
o
Ondina Sturges
10/19/2023, 4:26 PMYeah, I can only get this. Thought I had come across something in my google travels where a column could be highlighted via a different ‘hidden’ column 🤷♀️
t
Tim Chapman
10/19/2023, 4:28 PMI mean that you can add the formula to highlighting without making it a result as well.
o
Ondina Sturges
10/19/2023, 4:30 PMOh yes but that does the whole row which I don’t want
t
Tim Chapman
10/19/2023, 4:32 PMo
Ondina Sturges
10/19/2023, 4:44 PMappreciate it but it’s the same type of formula where it’s another column. doesn’t look like it’s possible to highlight the actual column itself. I’ll post back should I come across a solution.
m
MGBC
10/19/2023, 8:31 PMYeah unfortunately the only way to highlight a cell is with a formula which in turn negates the need to highlight it if you can’t fix/add the missing value
MGBC
10/19/2023, 8:33 PMYou could try to make all OTHER columns formulas with a color of white then use native highlighting to highlight the entire row
I don’t know if the formula background color will override the native highlighting but it might work 🤷♂️
I’ve never tried this but just a thought
o
Ondina Sturges
10/19/2023, 8:36 PMinteresting idea but in the grand scheme thing of things it’s more effort than it’s worth, a separate column will have to do, oh well