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

Formatting trouble

Mac

When I try to open the ".tiff" document in word, I get a box for "convert file", suggesting that the document is converted to a different format, no running. Previously, I had no problem opening up the same documents. Any thoughts? |Or if you do not have Photoshop any number of other graphics applications will open TIFF files, including the overview application included with OS X.I'm guessing, however...Read More

Posted: 18 Apr 2012

Tags: Formatting trouble Formatting trouble

Expanded Google goggles - Lazy Eye Syndrome, eyestrain and brain supposed formatting issues

Gadget

Any good eye doctor will tell you that there are tests, they can do with their machinery and equipment that can easily cause eyestrain. Similarly, anyone who knows anything on the HUD or Heads up displays also knows that people tend to get taken in the application of the target. There have been numerous studies by the military where of war veterans flight of aircraft or attack helicopters had crashed...Read More

Posted: 10 Apr 2012

Tags: Expanded Google goggles Lazy Eye Syndrome eyestrain and brain supposed formatting issues Expanded Google goggles Lazy Eye Syndrome eyestrain and brain supposed formatting issues

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