Hi all. Sorry if this is a basic question but my mind has gone blank!
I have a table. It doesn't matter how many rows or columns. I want to enter a value of "Y" in cell A1, and when I do, I want the rest of the cells in that row of the table, including A1, to conditionally format to a green fill.
Can anyone help? I know that this is a basic format but, honestly, it is driving me insane!
Thanks.
Bookmarks