When you return to the Conditional Formatting window, you should see the following. When the Format Cells window appears, select the font color that you'd like to see the client name displayed. Next, we need to select the color to use as the font color when our balance is exceeded.
Excel will automatically figure out the formula for all other cells in the highlighted range. This is why we used cell B2 as the cell to test the balance of. So in this case, we want to highlight all client names whose balance exceeds $245. Then enter the following formula: =B2>245īecause your first cell in the highlighted range is A2, you need to write the formula relative to this cell. The Font+Fill option allows you to change both the font and fill color of the cell with one keyboard shortcut In the example above, Ctrl+Shift+D will change the font and fill color of the cell to light green fill with dark green font. When the Conditional Formatting window appears, select " Formula Is" in the first drop down. Then select Conditional Formatting under the Format menu. In this example, we are highlighting cells A2 to A5. Question: In Microsoft Excel 2003/XP/2000/97, is it possible to format one cell based on the value of a different cell? I want to highlight a client's name if their balance due exceeds a certain value.Īnswer: To do this, we have our client names stored in column A with the corresponding balances in column B.īecause we want to highlight those client names whose balances exceed a certain value, highlight all of the client names.
EXCEL 2008 FOR MAC CHANGING FONT HOW TO
This Excel tutorial explains how to use conditional formatting to change the font color of a cell based on the value of another cell in Excel 2003 and older versions (with screenshots and step-by-step instructions). This Excel tutorial explains how to use conditional formatting to change the font color based on the value of a cell in Excel 2011 for Mac (with screenshots and step-by-step instructions).
MS Excel 2003: Change the font color in one cell based on the value in another cell MS Excel 2011 for Mac: Change the font color based on the value in the cell.
0 kommentar(er)
