Forum Discussion
Add text to a column based on text or color of another column
Hi there! I am trying to make a column in a document that autofills based on content contained in another column. Column A is a document's folder path so it has a lot of information that isn't us...
You wrote:
There are 4 potential column B values I need based on whether column contains a certain higher level folder. If it helps I have conditional formatted Column A based on the 4 values to each be different colors.
It potentially helps quite a bit: I wonder, for example, why you can't use whatever the "rules" are in your conditional formatting dialog box in connection with some solution -- an IFS function perhaps, or a table with VLOOKUP (or INDEX and MATCH--that follows the same logic to fill in your column B.