Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Copy Conditional Formats

I have a conditional format that I am trying to copy down
to multiple cells but am having a little trouble.

How do I copy this conditional format down

formula.......... =$R$2428="Yes"

Thank you
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Copy Conditional Formats

Hi
change the formula to
=R2428="Yes"

--
Regards
Frank Kabel
Frankfurt, Germany


MM wrote:
I have a conditional format that I am trying to copy down
to multiple cells but am having a little trouble.

How do I copy this conditional format down

formula.......... =$R$2428="Yes"

Thank you

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Copy Conditional Formats

Thank you so much
-----Original Message-----
Hi
change the formula to
=R2428="Yes"

--
Regards
Frank Kabel
Frankfurt, Germany


MM wrote:
I have a conditional format that I am trying to copy

down
to multiple cells but am having a little trouble.

How do I copy this conditional format down

formula.......... =$R$2428="Yes"

Thank you

.

Reply
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
Keeping Conditional Formats 'Constant' when copy & paste Porky79 Excel Discussion (Misc queries) 0 May 1st 09 02:11 PM
Copy Conditional Formats on a List jlclyde Excel Discussion (Misc queries) 2 January 6th 09 01:02 PM
Excel, how to copy conditional formats in sequential order 1,2,3 ShoDan Excel Worksheet Functions 6 July 3rd 07 01:54 PM
How do I copy conditional formats so it changes cell references? Chuckie E. Excel Worksheet Functions 2 October 20th 05 03:51 PM
How to create Conditional Formats that "grow" with copy/fill down. AliceNXLand Excel Discussion (Misc queries) 5 April 20th 05 05:07 PM


All times are GMT +1. The time now is 05:15 PM.

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

About Us

"It's about Microsoft Excel"