View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
~L ~L is offline
external usenet poster
 
Posts: 177
Default Conditional Formatting within a Formula

In the conditional formatting menu, choose "Format Is" and put =I36H36 and
choose the format to apply. By default, when selecting a cell, it will apply
absolute references ($I$36$H$36) so be sure to remove the $.

Without the $, the conditional format should update when you drag it.

"Connie Martin" wrote:

How do I use conditional formatting in this way:
IF I36 is greater than H36, then bold red font
IF I36 is less than H36, then bold blue font

If it were just the one cell, it would be simple but I want that to carry
down, so that I37 jives with H37 and then I38 with H38, and so on.

Connie