Hi.
I have created a schedule sheet where one row indicates the closed schedule and below that row I want to show what has been changed.
If anything shows up in the cell, I did a Conditional Formatting to change color so it would stand out. The thing is, I also want the word "Changes" to appear as a title for that particular row.
ex:
mon tue wed thur
Jane Doe X no x x
Changes x
The word "Changes" should only appear if there were any changes made on that row (which I will add a conditional formatting to match the color of the changes under the days).
The thing is, the change codes could be a number of choices. Its not just X and no....there is AANN, OT, TOP, etc. I don't know the whole list of choices.
I tried: if(istext(D8:AB8),"Changes","") - which didn't work....
Any help would be greatly appreciated!
Thank you.
Bookmarks