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 |
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