Hello,
I have a named table named "TBIS" which has a column named "Source". I'm attempting to format the table so that when a new entry is input which has the word "Adjustment" as the "Source" column, the entire row of that entry turns blue. I have been able to do it using the following conditions:
Format values where this formula is true
=INDIRECT("E"&ROW())="Adjustment"
Applies to
=TBIS
The problem using this method is that it looks for column e, rather than the "Source" column (which happen to be the same column). I want it to reference the "Source" column, as the column may change locations, so I tried replacing the E in the formula above with the below formula, but it returns an error.
SUBSTITUTE(ADDRESS(1,COLUMN(TBIS[Source]),4),1,"")
Is there any way to have the formula look for the word "Adjustment" in the "Source" column and format the entire line blue?
Thanks!
Bookmarks