close

I want to create a formula where a cell will automatically be shaded a
certain color if a number is gt;= a certain number

Select the cell or cells that you want to shade. go to FORMAT-gt;CONDITIONAL
FORMATING. Use the drop down box to choose greater than or equal to, in the
right most box enter the value Click the format button to pick the shading
you want. Click Okay and you are done.

Formula example

quot;Rafi2288quot; wrote:

gt; I want to create a formula where a cell will automatically be shaded a
gt; certain color if a number is gt;= a certain number

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()