Prev: using a IF statement to return a value
Next: Help with Value in one column...
From: tech1NJ on 26 Mar 2010 23:34
Assuming that your number start at A2 to A4 and B2 to B4 try this
Highlight B2 to B4, then go to conditional formatting and select "Cell is",
"Equal greaterthan", Select A2 to A4 then choose your format (red).
--
tech1NJ


"Yrrep" wrote:

> When I try to select all of column B and CF then "greater than", then select
> all column A, then color red
> I get "cannot use direct reference to a worksheet range in a conditional
> format formula."
>
>
>
>
> "tech1NJ" <tech1NJ(a)discussions.microsoft.com> wrote in message
> news:CCCAA496-EED5-4ED6-8A4C-C4342DAAA43B(a)microsoft.com...
> > Try highlighting all the Cells in Column B then perform your conditional
> > formating again. You can not copy and paste this function.
> >
> >
> > --
> > tech1NJ
> >
> >
> > "Yrrep" wrote:
> >
> >> A B
> >> Range Average
> >> 200.0 46.0
> >> 500.0 120.0
> >> 3900.0 1733.0
> >> 950.0 485.0
> >> 3000 3317.0
> >> 4.8 4.0
> >> 2.0 1.2
> >> 136.0 87.1
> >> 40.0 17.2
> >> need some way to color column B red, if greater than column A
> >>
> >> I tried to conditional format but when I copy down it don't work
> >>
> >> There are actually 63 rows and 43 columns.
> >>
> >>
> >> .
> >>
>
>
> .
>
From: Yrrep on 27 Mar 2010 09:23
thanks tech1 NJ from yrrep also in NJ

when I do what you suggest I get the following error message

cannot use direct reference to a worksheet range in a conditional format
formula

Change reference to a single cell, or use reference with a worksheet
function as =sum(a1:e5)

the only way I can get it to work is to do each row one at a time, that 84
times

thanks Microsoft

"tech1NJ" <tech1NJ(a)discussions.microsoft.com> wrote in message
news:A6A54ECF-BCC4-44E6-90A9-A7F542155A89(a)microsoft.com...
> Assuming that your number start at A2 to A4 and B2 to B4 try this
> Highlight B2 to B4, then go to conditional formatting and select "Cell
> is",
> "Equal greaterthan", Select A2 to A4 then choose your format (red).
> --
> tech1NJ
>
>
> "Yrrep" wrote:
>
>> When I try to select all of column B and CF then "greater than", then
>> select
>> all column A, then color red
>> I get "cannot use direct reference to a worksheet range in a conditional
>> format formula."
>>
>>
>>
>>
>> "tech1NJ" <tech1NJ(a)discussions.microsoft.com> wrote in message
>> news:CCCAA496-EED5-4ED6-8A4C-C4342DAAA43B(a)microsoft.com...
>> > Try highlighting all the Cells in Column B then perform your
>> > conditional
>> > formating again. You can not copy and paste this function.
>> >
>> >
>> > --
>> > tech1NJ
>> >
>> >
>> > "Yrrep" wrote:
>> >
>> >> A B
>> >> Range Average
>> >> 200.0 46.0
>> >> 500.0 120.0
>> >> 3900.0 1733.0
>> >> 950.0 485.0
>> >> 3000 3317.0
>> >> 4.8 4.0
>> >> 2.0 1.2
>> >> 136.0 87.1
>> >> 40.0 17.2
>> >> need some way to color column B red, if greater than column A
>> >>
>> >> I tried to conditional format but when I copy down it don't work
>> >>
>> >> There are actually 63 rows and 43 columns.
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>>


First  |  Prev  | 
Pages: 1 2
Prev: using a IF statement to return a value
Next: Help with Value in one column...