conditional formating cells i Excel based on other cells values

[Guest]

is it possible to use conditional formating based on the value in other cell

that is can I use conditional formating in cell A3 based on the value in
cell A1

 

[Ardus Petus]

The answer is YES!

HTH

 

[Guest]

Elias,

On the conitional formating box change the 1st box to Formula.

Marcelo - Brazil



"Elias Petursson" escreveu:

 

[Guest]

is it possible to use conditional formating based on the value in other cell
that is can I use conditional formating in cell A3 based on the value in
cell A1

Yes, perhaps a quick tinker to illustrate ..

Select A3
Click Format > Cond Formatting
Under Condition 1, make it as:
Formula is: =A1>10
Click Format button > Patterns tab > Green? > OK
Click OK at the main dialog

Test it out ..
Input a figure > 10 into A1, A3 should be filled green
Change A1 to a fig less than 10, A3's green fill would disappear

---