If statement to change colour

  • Thread starter digitallifeform
  • Start date
D

digitallifeform

Hi all

I need to know if i can get excel to change the colour of text (or
cell) from an 'if' statement. For example: if <this> mathes <that>
change colour to red.

If that's not possible, anything that can change the appearance of the
cell or text.

Many thanks
 
P

Paul

digitallifeform said:
Hi all

I need to know if i can get excel to change the colour of text (or
cell) from an 'if' statement. For example: if <this> mathes <that>
change colour to red.

If that's not possible, anything that can change the appearance of the
cell or text.

Many thanks
Click to expand...

Conditional formatting on the Format menu.
 
V

Vulpes Argenteus (formerly M)

Hi all

I need to know if i can get excel to change the colour of text (or
cell) from an 'if' statement. For example: if <this> mathes <that>
change colour to red.

If that's not possible, anything that can change the appearance of the
cell or text.
Click to expand...

Difficult to say from your limited description but "Conditional Formatting"
may well do what you need. Have a read about it in the help-file and have a
play.

Cheers
 
S

Steve Farrar

The only way I know is programmatically -i.e using VBA- code like this would do it:

If Range("a3") = 15 Then Range("a3").Interior.ColorIndex = 12
 
Top