conditional formatting

Mac

Question:How to use CF the color of an entire row if they contain a certain word.I searched the net and cannot find an answer to this simple question.I use Excel 2011 on a Mac.Thank youAnswer:You must be a little more specific. What do you mean by "a whole line" and"contain a certain word?Read More

Posted: 19 Apr 2012

Tags: conditional formatting conditional formatting

Excel 2007: Add additional Conditions for the conditional formatting

Office

Question:I do not find the tool to add a second or a third condition of conditional formatting in Excel 2007 file.What he calls? I don't remember what was called the tool in Excel 2003.KelliAnswer:Select the home Ribbon tab.In the Styles group, click conditional formatting > new rule..., or if you want to review the existing rules first, click on conditional formatting > manage rules... The...Read More

Posted: 02 Apr 2012

Tags: Excel 2007 Add additional Conditions for the conditional formatting Excel 2007 Add additional Conditions for the conditional formatting

Dates and the conditional formatting

Office

Question:HelloI need to a conditional formatting formula which will focus on a cell (B2) where the date of entry in this cell isnot between 01/01/2009 and the current date. The date of 01/01/2009 is already entered in a cell to say the different spreadsheet A2 of sheet 2.I looked through the different threads but cannot find an answer.Thanks for any helpAnswer:First, you must define a name for the...Read More

Posted: 24 Mar 2012

Tags: Dates and the conditional formatting Dates and the conditional formatting

conditional formatting of empty cell

Office

Can I form an entire row if the cell in a date column is empty? |Let's say that you want to apply to the range of A1: D100.Select the range and apply CFIf you want to format the line when a certain cell (say, column C) is empty, then use this formula in the development in the form of dialog = ISBLANK($C1) conditioanlIf you want that formatting if a cell is empty: = COUNTIF($A1:$D1,"") > 0Couce...Read More

Posted: 19 Mar 2012

Tags: conditional formatting of empty cell conditional formatting empty cell

conditional formatting based on the difference in value of two cells

Office

Question:I use Excel 2007.Try to use the conditional formatting so that, if the difference in the value in cell B7 and C7 is greater than 100 to change the colors of these two cells in red.Is it possible?= "If (abs (b7 - b8) > 100)" is the format that I have, but it is not workingAnswer:... If the difference of the value in cell B7 and C7 is greater than 100 to change the colors of these two cells...Read More

Posted: 13 Mar 2012

Tags: conditional formatting based on the difference in value of two cells conditional formatting based the difference value two cells