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
|