Conditional Format

  • Thread starter Thread starter MS Forum Newsgroup User
  • Start date Start date
M

MS Forum Newsgroup User

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

petedacook said:
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.
Click to expand...
 
Back
Top