|
|
#1
03-06-2015, 07:54 AM
|
|||
|
|||
Copying Conditional Formating
I have a worksheet where if I type "yes" in a cell the line turns green, when I type "no" the line turns red. I am unclear on how to copy the conditional formatting from line to line. I have tried changing the range to encompass all the worksheet, but when I do that the whole worksheet changes according to the top right cell. I am attaching my work file. Any direction will be greatly appreciated. Thanks 
|
| Tags |
| conditional formatting, copy format |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Conditional Formating | MaineLady | Excel | 1 | 11-05-2014 06:37 PM |
| Chart Formating with ChartTitle Font and DataLabel Formating | shilabrow | Excel Programming | 0 | 06-30-2014 10:01 AM |
| Formating for buletts | YooNaa Kim | Word | 5 | 05-04-2012 11:49 PM |
 more Conditional Formating
|
princeofsadness | Excel | 2 | 09-05-2011 02:14 AM |
| After formating PC | milkmile | Outlook | 2 | 10-12-2010 06:58 AM |
Windows 8 
Office 2013
Threaded Mode