Conditional formatting

New Contributor


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.


2 Replies
best response confirmed by Hans Vogelaar (MVP)

@bushra2145 Such a rule could be like this:


File attached.

Dear Riny,
Thank you! it worked brilliantly.