conditional formatting

[oldLearner57]

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

 

[Jacob Skaria]

The 1st applicable conditional formatting rule is applied. So your second
condition will not work.

If this post helps click Yes