Copying conditional formatting to entire sheet

S

slyguy2183

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.
 
M

Max

Remove the "$" sign from the row ref in the CF formula,
eg instead of: =$B$1=5
change it to: =$B1=5
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting and Cell References 10
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
"Fill" Conditional Formatting? 5
Copying Conditional Formatting 3
Conditional formatting Entire Row Based on single Cell Value 5
Conditional formatting to color rowsbased on cell value 1
Copying conditional formating 2
Excel Conditional Formatting 1

Top