Coloring certain cells

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

Guest

Dear all !

I have in one spreadsheet, ten columns (from A14 to J77) which are doing
different calculations.
Because of the nature of calculations one of cells in column E has to be
equal to 1.

My question is:
If lets say cell e60 turns to be 1. Is there any way to color automatically
this cell and all the other cells in row from A60 to J60 (lets say in Yellow)

Thank you in advance
 
Select A14:J77 (with A14 active) and then:

Format | Conditional Formatting | Formula Is | =$E14=1 | Format | Patterns |
Yellow | OK | OK
 
Hi Tim

You can use Condition Formating...

Select range A60 to J60

From Tools | Condition Formatting...

Change to Cell Value Is To Formula Is and type in the formula

=$E60=1

Click on the format and select the paterns you want.

Hope this help


Dear all !

I have in one spreadsheet, ten columns (from A14 to J77) which are doing
different calculations.
Because of the nature of calculations one of cells in column E has to be
equal to 1.

My question is:
If lets say cell e60 turns to be 1. Is there any way to color automatically
this cell and all the other cells in row from A60 to J60 (lets say in
Yellow)

Thank you in advance
 
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

Cell Color Recognition and Summing of Data Within a Specified Colo 1
create a formula based on cell color 2
Color coding cells 2
how can I use conditional formatting with formula and 3 poss resul 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Merge data from two separate tables 1
How can I automatically color a cell based upon a condition being 4
Adding certain cells in one column 4

Back
Top