Conditional Formatting - multiple columns

Options

Hi All,

Hope you are all safe.

Is it possible to apply conditional formatting to multiple columns (same condition).

I have data in 10 columns. I want to highlight cells where the value is not equal to 0.

Currently I have to apply conditional formatting to each column separately (cloning the rule).

Is there a faster way?

Regards,

Abhiraj Joshi

Best Answer

Answers