how do you format a row of cells based upon a value in another ce.

H

hazenb1

how do you format a row or a range of cells based upon a value in a cell not
included in the conditional format?
 
J

JulieD

Hi

select the cells to have the conditional formatting on them
choose format / conditional formatting
choose formula is
type the criteria (ie =$E$1>50)
click the format button to apply the formatting.

Cheers
JulieD
 
Top