If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#18
|
|||
|
|||
Incorporating Cell color fill in an "if" logical function?
You can still apply the formatting to the entire range at once.
Let's assume you want to format A1:A10 if the cells contain Yes. Select the *entire* range A1:A10 starting from cell A1. A1 will be the active cell. The active cell is the one cell in the selected range that is not shaded. The formula used is relative to the active cell. Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =A1="Yes" Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Geo." wrote in message ... So is it now true in Excel 2007, that I have to apply conditional formatting to each cell individually (in this case). In 2003, I was able to drag the cell formatting down a long list of items where the formulas were relative so the row number changed as I went from cell to cell. Excel 2007 seems to want to lock everyting to a specific cell e.g., $m$4. If this is the case, it is terrible. Perhaps I have missed something. I certainly hope so. "T. Valko" wrote: I am using vista and excel 2007. Try this... Assume the cell in question is A1 Select cell A1 Goto Home tabStylesConditional FormattingManage Rules Click New RuleUse a formula to determine..... Enter this formula in the box: =A1="I" Click the Format button Select the desired style(s) OKOKApply Now, click New Rule and repeat the process for each of the conditions. This was much easier in previous versions of Excel! -- Biff Microsoft Excel MVP "Shawn" wrote in message ... I have a similar question to this thread... I have a cell that contains an if statement that returns either I, II, III or IV depending on criteria. Can I also make the cell turn a different colour for each of these results? e.g. (Red for I, Orange for II, etc.) I used to know how to do this in the old excel, but now I am using vista and excel 2007. Thanks. Shawn "Miguel Zapico" wrote: You can use Format-conditional formating, select "Formula is", and insert the condition that evaluates to true/false in the text box. Hope this helps, Miguel. "George_Sky" wrote: I want to identify a specific cell by highlighting it with a cell fill color when an "if" statement returns a "ture" response. How do I do this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Urgent date/scheduling calc needed | jct | Worksheet Functions | 3 | February 24th, 2006 01:36 AM |
Function syntax to compare cell contents | ES | Worksheet Functions | 2 | May 18th, 2005 03:53 PM |
IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |
If/And function help | Milehigh | Worksheet Functions | 5 | January 30th, 2004 04:15 PM |
Convert a Cell Reference to Text | Chuck Buker | Worksheet Functions | 6 | September 22nd, 2003 05:04 PM |