Is this possible with microsoft excel?

annoyingmi

New Member
Joined
Dec 3, 2005
Messages
19
Hi, I have a doubt to clarify.
heres what i wanted to do, lets say for example,
if my question was..

Highlight loss (negative income) in red and bold it.
Highlight profit above a certain lets say >$10,000 in blue and italic it.

Is it possible to command excel to do such things?

Programming excel to italic/bold/underline or even change the font colour if the value was exceeding a certain amount.

Thanks in advance. =D
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
Sure.

Have a look at conditional formatting (format --> conditional formatting).
 

wwbwb

Well-known Member
Joined
Oct 20, 2003
Messages
513
Got Format -> Conditional Formatting

You can tell excel to change colors formats etc when certain conditions are met.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,081
Messages
5,570,089
Members
412,310
Latest member
mark884
Top