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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do you format a row or a range of cells based upon a value in a cell not
included in the conditional format?
 
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
 
You must log in or register to reply here.

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

can conditional formatting varry the area it highlights based on c 3
Excel VBA 1
Conditional Format a range based on 1 cell 1
Conditional format order priority 2
Excel Conditional Formatting 1
conditional formatting based on the value of another cell 8
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Conditional formatting, based on a different cell? 3

Back
Top