View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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