conditional formatting?

K

kkondrat1

Hello, i have a column with random numbers ranging from 1 to 100.

I tried to use conditional formatting to hilight all the rows that hav
a number > 50, unfortunately it only colors the cell. How can I get i
to color the entire row
 
F

Frank Kabel

Hi
lets say your data is in A1:A10:
- select the rows
- goto the conditional format dialog
- enter the following formula
=$A1>50
 
G

Gord Dibben

Select Rows(not cells) 1 through 100.

Format>CF>Formula is: =$A1>50

Pick a color and OK your way out.

Gord Dibben Excel MVP
 
Top