Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Copying conditional formatting to entire sheet

I've worked out how to format a row based on one cell in the row but when I
try to copy that formula to my entire sheet every row's color is conditional
to the value of the first cell, not the cell for each respective row.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 461
Default Copying conditional formatting to entire sheet

Can you show what formula you are using?

"slyguy2183" wrote:

I've worked out how to format a row based on one cell in the row but when I
try to copy that formula to my entire sheet every row's color is conditional
to the value of the first cell, not the cell for each respective row.

  #3   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Copying conditional formatting to entire sheet

Remove the "$" sign from the row ref in the CF formula,
eg instead of: =$B$1=5
change it to: =$B1=5
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"slyguy2183" wrote:
I've worked out how to format a row based on one cell in the row but when I
try to copy that formula to my entire sheet every row's color is conditional
to the value of the first cell, not the cell for each respective row.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Copying conditional formatting to entire sheet


How do you copy ithe conditional formatting to the row?
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
Conditional Formatting Precidence when copying to new sheet in 200 MIRA Excel Discussion (Misc queries) 0 April 25th 08 11:43 AM
Copying formatting of entire sheet Diamontina Cocktail New Users to Excel 5 June 27th 07 10:50 PM
conditional formatting for entire row h20polo Excel Discussion (Misc queries) 2 June 20th 07 09:09 AM
Conditional Formatting Entire Row Daviv Excel Discussion (Misc queries) 1 December 18th 06 07:58 PM
copying conditional formatting to an entire column MaryMalone Excel Discussion (Misc queries) 1 November 30th 04 04:04 AM


All times are GMT +1. The time now is 03: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"