Menu Bar (Click
on the buttons below to rediscover Excel) |
Conditional Formatting You would like that when the value of a cell is greater then $50 the font turns blue and the background color changes to green. You need "Conditional Formatting". Select the cell or the cells where you want this to happen go to the menu bar Format/Conditional Formatting and the following window appears (may vary depending on the Excel version that you useyou use).
Select "greater than" in the second text box, enter 50 in the third text box and then click on the "Format" button. Choose blue as color for the font and select the "Patterns" tab and select the color green. Now if you write any number greater than 50 in one of the formatted cells the color of the font and of the background will change. If the value is smaller than 50 the default format is selected. When you don't want zero values to appear in a worksheet............. |
Menu Bar (Click
on the buttons below to rediscover Excel) |