Coloring certain cells

T

Tim

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
 
V

Vasant Nanavati

Select A14:J77 (with A14 active) and then:

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

kk

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
 
Top