| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Painter in Excel 2007
I set a conditional format in a cell (A1) using a formula (=B1="") to make
the cell red if cell B1 is blank. I then used the Format Painter to copy this conditional format to other cells - say A2 thru A100. If I look at the conditional format in cell A47, why does it tell me that this conditional format formula is =B2="", and that it "Applies to $A$2:$A$100"? I liking Excel 2007 less and less each day. -- Bill @ UAMS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the hotkey for format painter in excel | Excel Discussion (Misc queries) | |||
| Format Painter in 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007, Conditional Formatting, Format Painter | Excel Discussion (Misc queries) | |||
| Excel should allow you to use the format painter on a graph | Charts and Charting in Excel | |||
| Disable format painter in excel 2003 | New Users to Excel | |||
Threaded Mode
