| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting based on text within a formula | Excel Worksheet Functions | |||
| conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Need conditional formatting formula to highlight top ten values i. | Excel Worksheet Functions | |||
| Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Linear Mode
