If statement to change colour

  • Thread starter Thread starter digitallifeform
  • Start date 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
 
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.
 
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
 
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
 
Back
Top