Conditional Formatting

S

StompS

I have a conditional format in one cell that is correct and want to apply it
to all cells in that column.I thought I should be able to copy the formula
then select the entire column and goto conditional fromatting and paste the
formula. The formula references cells tht are noted as (for example) "B1"
not "$B$1" so the cell reference should change for each cell. Did I do
something wrong? Because it is not working as expected (wrong cell
references in the formula). Thanks!
 
C

Cutter

Not too clear on what you're asking but try this:

Highlight all the cells in the column to which you want the CF to apply
(starting with the cell that has the correct formula).
If you want all the highlighted cells to refer to one cell then use the
$'s (to set an absolute reference)
If you want each cell in the column to refer to another cell a
proportionate number of cells down then remove the $'s
Click on OK
 
C

Cutter

Not too clear on what you're asking but try this:

Highlight all the cells in the column to which you want the CF to apply
(starting with the cell that has the correct formula).
If you want all the highlighted cells to refer to one cell then use the
$'s (to set an absolute reference)
If you want each cell in the column to refer to another cell a
proportionate number of cells down then remove the $'s
Click on OK
 
Top