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

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
>
> .
>

Thanks Pete.

"petedacook" <(E-Mail Removed)> wrote in message
news:C56E5CC1-F77C-4AED-A7D5-(E-Mail Removed)...
> 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
>>
>> .
>>