conditional formatting

J

JulieD

yes

for example
click in say cell B1
choose format / conditional formatting
choose
formula is
type
=A1>5
click format
set a format
click Ok twice
now change the value of A1 to +-5

Cheers
JulieD
 
E

esslinger

Is is possible to set a conditional format for one cell
dependent on the value of a different cell?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Referencing the values of multiple cells in conditinal formatting. 0
Paragraph numbering in Word 1
Conditional Formatting 3
Conditional Formatting Formula 3
CONDITIONAL FORMATTING IN EXCEL 2010 1
Conditional Formatting question.... 1
vlookup formatting problem 1

Top