color-coding cells and more

  • Thread starter Thread starter Old guy
  • Start date Start date
O

Old guy

Excel 97 / W98
Two easy questions.
Is there a way to color-code a cell based on a condition, BUT not using
Visual Basic Editor?
That is, I want to change a cell based on a condition using the =IF(a,b,c)
format.
In the status bar, I have choices of SUM, Average, and a few others.
Always opens with SUM as the default option. Can I change the default to
'Average?'
 
Old said:
Is there a way to color-code a cell based on a condition, BUT not
using Visual Basic Editor?
That is, I want to change a cell based on a condition using the
=IF(a,b,c) format.
Click to expand...

Use Conditional Formatting. See Excel help for details.

Dave
dvt at psu dot edu
 
Back
Top