ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I create a formula where a cell is automatically shaded ? (https://www.excelbanter.com/excel-worksheet-functions/84384-how-do-i-create-formula-where-cell-automatically-shaded.html)

Rafi2288

How do I create a formula where a cell is automatically shaded ?
 
I want to create a formula where a cell will automatically be shaded a
certain color if a number is = a certain number

PAR

How do I create a formula where a cell is automatically shaded ?
 
Select the cell or cells that you want to shade. go to FORMAT-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

"Rafi2288" wrote:

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



All times are GMT +1. The time now is 10:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com