Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |