Conditional Format
 

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

Conditional Format
 

You should be able to copy the cell with the conditional formatting, then
PasteSpecialFormats 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

.

Conditional Format
 

Thanks Pete.

"petedacook" wrote in message
...
You should be able to copy the cell with the conditional formatting, then
PasteSpecialFormats 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

.