| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I copy a format that.........
I have a format set for cell (b2). this format analyzes the value of cell
(a2). If the value of (a2)and(b2)are equal then the text shows in green. If not, the text shows in red. Ok....YAY.... Now how do I go about formating an entire column(b) to do this with column(a)? Sounds stupid but everytime I try using the format painter then (b3) for example still analyzes (a2) rather then analyzing (a3). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| copy with format | New Users to Excel | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
| copy conditional format to regular format | Setting up and Configuration of Excel | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Threaded Mode
