|
Conditional Formatting within a Formula
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 |
Conditional Formatting within a Formula
Condition 1: Formula: H36 then bold red
Condition 2: Formula: <H36 then bold blue font Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "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 |
Conditional Formatting within a Formula
Dave, thank you, but if you are meaning to go to Format/Conditional
Formatting, I did that as you have shown here, and ever cell in the I column looks at H36 all the way down. Connie "Dave F" wrote: Condition 1: Formula: H36 then bold red Condition 2: Formula: <H36 then bold blue font Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "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 |
Conditional Formatting within a Formula
If every row looks at H36, I would guess that your formula says H$36, rather
than H36? Get rid of the unwanted $. -- David Biddulph "Connie Martin" wrote in message ... Dave, thank you, but if you are meaning to go to Format/Conditional Formatting, I did that as you have shown here, and ever cell in the I column looks at H36 all the way down. Connie "Dave F" wrote: Condition 1: Formula: H36 then bold red Condition 2: Formula: <H36 then bold blue font "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 |
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 |
Conditional Formatting within a Formula
Nope. I took out the $. Doesn't work. Will try this again in the morning.
I'm going home. Connie "David Biddulph" wrote: If every row looks at H36, I would guess that your formula says H$36, rather than H36? Get rid of the unwanted $. -- David Biddulph "Connie Martin" wrote in message ... Dave, thank you, but if you are meaning to go to Format/Conditional Formatting, I did that as you have shown here, and ever cell in the I column looks at H36 all the way down. Connie "Dave F" wrote: Condition 1: Formula: H36 then bold red Condition 2: Formula: <H36 then bold blue font "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 |
| All times are GMT +1. The time now is 10:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com