Prev: Named Range
Next: Autofill Formula
From: MS Forum Newsgroup User on 24 Mar 2010 09:48
Hi,

I am creating a conditional format which is based on a value form another
cell say:

if value is less than: =If(r14=14,20,30)

however can I set the cell to be relative rather than one cell?

Thanks

From: petedacook on 24 Mar 2010 11:44
You should be able to copy the cell with the conditional formatting, then
Paste>Special>Formats over all the cells you wouold like to have the
conditional formatting.



"MS Forum Newsgroup User" wrote:

> Hi,
>
> I am creating a conditional format which is based on a value form another
> cell say:
>
> if value is less than: =If(r14=14,20,30)
>
> however can I set the cell to be relative rather than one cell?
>
> Thanks
>
> .
>
From: MS Forum Newsgroup User on 24 Mar 2010 17:59
Thanks Pete.

"petedacook" <petedacook(a)discussions.microsoft.com> wrote in message
news:C56E5CC1-F77C-4AED-A7D5-3DBD7BDD72A6(a)microsoft.com...
> You should be able to copy the cell with the conditional formatting, then
> Paste>Special>Formats over all the cells you wouold like to have the
> conditional formatting.
>
>
>
> "MS Forum Newsgroup User" wrote:
>
>> Hi,
>>
>> I am creating a conditional format which is based on a value form another
>> cell say:
>>
>> if value is less than: =If(r14=14,20,30)
>>
>> however can I set the cell to be relative rather than one cell?
>>
>> Thanks
>>
>> .
>>
 | 
Pages: 1
Prev: Named Range
Next: Autofill Formula