LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default Copy formating from above row if value is entered

How do i copy cell's formating in column B from column B 1 row above if any
value is entered into same row's cell in column A

For example if i enter any value in cell A7 then formating (including
conditional formating) of Cell B6 should be copied to cell B7
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Visual to copy format one row down when data entered Jeremy Excel Discussion (Misc queries) 1 November 5th 09 04:20 PM
Copy last data entered into mulitiple sheets within a workbook? Big Al[_2_] Excel Discussion (Misc queries) 2 April 9th 09 04:50 PM
Conditional Formating working when data is entered later ConnieH Excel Worksheet Functions 1 March 19th 07 08:40 PM
Copy formula automatically down when date is entered tommylux Excel Discussion (Misc queries) 15 October 11th 06 04:51 PM
Cannot copy or move array entered formulas ... shared workbk JimDerDog Excel Worksheet Functions 0 May 26th 05 04:17 PM


All times are GMT +1. The time now is 10:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"