Forum Discussion
Conditional Formatting Multiple Cells/Columns Based on Previous Cells
That could be like
=(E2>D2)*(D2>0)*(COLUMN()<>COLUMN(INDIRECT("Table1[[#Headers],[f18]]")))for the yellow rule and similar for other (see attached file). Last multiplier is to exclude first column, or you may apply rules to your table starting from the second column.
That could be like
=(E2>D2)*(D2>0)*(COLUMN()<>COLUMN(INDIRECT("Table1[[#Headers],[f18]]")))
for the yellow rule and similar for other (see attached file). Last multiplier is to exclude first column, or you may apply rules to your table starting from the second column.
Thank you so much for the help! It worked for me.
Followup question: Is it possible to create an intuitive/automated version of this conditional formatting, that it will automatically format new columns added to the table?
Again, thank you!
charmbrooksrunning , you are welcome
If you add the column through this menu
conditional formatting range will be automatically expanded.
However, if you start adding data to the right of the table, new column will be added to the table automatically, but this time without the expanding of the conditional formatting range.
