Conditional formatting

[bushra2145]

Hello,

I have a dataset in which three columns corresponding to their respective IDs have different values. Some have 0 and some have higher values. I want to select the IDs which have two columns with values higher than 0. I have used conditional formatting to highlight the cells with values greater than 0 but I don't know how to select two columns.

Any help would be appreciated.

Thank you.

Bushra

[#2 · Accepted solution]

@bushra2145 Such a rule could be like this:

File attached.

[#3]

Dear Riny,
Thank you! it worked brilliantly.