Hi, not sure if this is a job for conditional formatting or VBA. My goal is to be able to have font formatting in a range of cells change to match if any other cells in the row have formatted text. So in my example below, since G18 has bold red text, I would want A18:E18 to show up bold red. K19 is bold blue, so A19:E19 should be bold blue. I20 is bold magenta so A20:E20 should be bold magenta.
Tables will not always have the same amount of rows or columns...but I'm always going to want A:E to match based on if any cells in the rest of the row starting at G have any text formatting.
Hopefully this makes sense and is possible somehow? It's Friday. My brain is mush
Thanks in advance for any insight!
Tables will not always have the same amount of rows or columns...but I'm always going to want A:E to match based on if any cells in the rest of the row starting at G have any text formatting.
Hopefully this makes sense and is possible somehow? It's Friday. My brain is mush

Thanks in advance for any insight!