Conditionl Format

T

TeddyTash

Is it possible to do the following:

I want to make a cell change color depending on the value of a
different cell.

So for example if A2 = "100" then I want cell A1 to change color.

Please help!
 
S

swatsp0p

check out Format>Conditional Formatting... on the main menu... EXACTL
what you are looking for...

Good Luck

Bruc
 
G

Gord Dibben

Teddy

Select A1 and Format>CF>Formula is =A2=100

Format to a color under Format>Patterns and OK.


Gord Dibben Excel MVP
 
Top