If/Then formatting
Here is an example for B1. If B1 is greater than A1, we want B1 highlighted:
Click on B1 and:
Format Conditional Formatting... . Formula Is
=B1A1
and then pick a nice color.
--
Gary''s Student - gsnu200772
"John" wrote:
Novice here
I would like to highlight/color a cell if the number of that cell exceeds
the number of the cell next to it. The cell I would like to color already has
a formula for adding in it.
Any help is greatly appreciated
John
|