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

.