conditional formatting?

  • Thread starter Thread starter kkondrat1
  • Start date Start date
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
 
Hi
lets say your data is in A1:A10:
- select the rows
- goto the conditional format dialog
- enter the following formula
=$A1>50
 
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
 

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

Excel VBA 1
conditional formatting - color 3
Excel Conditional Formatting 1
Excel Macro to automatically go to the right of the last colored cell 0
Conditional format lowest value greater than zero and copy formula 2
Conditional Format a range based on 1 cell 1
Conditional format for unique values 5
Formatting cell 2

Back
Top