conditional formating cells i Excel based on other cells values

E

Elias Petursson

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
 
M

Marcelo

Elias,

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

Marcelo - Brazil



"Elias Petursson" escreveu:
 
M

Max

Elias Petursson said:
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
Click to expand...

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
 
Top