View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MS Forum Newsgroup User MS Forum Newsgroup User is offline
external usenet poster
 
Posts: 4
Default 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

.