hi community

how can i use the Conditional Formatting to format 2 criteria at a same
time, an example:

condition 1

if the cell value is greater than 0, it will format a shade color of gray

condition 2

if the cell value is than than 1, it will format a red border line
surrounding the cell

so, if now my cell contain a value of 2, the cell will have a shade of gray
and a border color of red.

any help on this ???

thanks community for kind assistance

:)
--
oldLearner57