| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
value in cell B < value in cell A conditional format
In excell 2007 I have a "=count(C2:BE2)" column and a "=countif(C2:BE2, "
0")" column. I want to conditional format the count colum if it is less than the countif column. When I follow instructions for conditional format to write a formula that is "true" and enter B < A (or B A) nothing happens. If I specify the row numbers ( B2 < A2 ) nothing happens. How do I make this happen? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
value in cell B < value in cell A conditional format
Select your count column (which I presume is column B). Assuming the countif
column is column A Format - Conditional Format Formula is: =B1<A1 Click format, choose pattern color you desire, then 'ok'. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "JR" wrote: In excell 2007 I have a "=count(C2:BE2)" column and a "=countif(C2:BE2, " 0")" column. I want to conditional format the count colum if it is less than the countif column. When I follow instructions for conditional format to write a formula that is "true" and enter B < A (or B A) nothing happens. If I specify the row numbers ( B2 < A2 ) nothing happens. How do I make this happen? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
value in cell B < value in cell A conditional format
Try it like this:
=$B2<$A2 -- Biff Microsoft Excel MVP "JR" wrote in message ... In excell 2007 I have a "=count(C2:BE2)" column and a "=countif(C2:BE2, " 0")" column. I want to conditional format the count colum if it is less than the countif column. When I follow instructions for conditional format to write a formula that is "true" and enter B < A (or B A) nothing happens. If I specify the row numbers ( B2 < A2 ) nothing happens. How do I make this happen? Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
value in cell B < value in cell A conditional format
Thanks Luke M -- it worked ... but only after I tried it the second time, so
you got a no help ... post again and I'll give it a GO! JR "Luke M" wrote: Select your count column (which I presume is column B). Assuming the countif column is column A Format - Conditional Format Formula is: =B1<A1 Click format, choose pattern color you desire, then 'ok'. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "JR" wrote: In excell 2007 I have a "=count(C2:BE2)" column and a "=countif(C2:BE2, " 0")" column. I want to conditional format the count colum if it is less than the countif column. When I follow instructions for conditional format to write a formula that is "true" and enter B < A (or B A) nothing happens. If I specify the row numbers ( B2 < A2 ) nothing happens. How do I make this happen? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format - value of one cell greater than another cell | Excel Worksheet Functions | |||
| conditional format if cell contains the text IQ anywhere in cell | Excel Discussion (Misc queries) | |||
| conditional format if cell contains link to another cell | Excel Discussion (Misc queries) | |||
| conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
| Format of one cell conditional on another | Excel Worksheet Functions | |||
Linear Mode
