Forum Discussion

Sameer_Kuppanath_Sultan's avatar
Sameer_Kuppanath_Sultan
Brass Contributor
Jan 17, 2021

Printing a specified area without color!!

  Hi All   I want to print the below with Area 1 (Green Color) in "color" and area 2 (Blue Color) in "black and white", is it possible??            
excel
Wyn Hopkins's avatar
Wyn Hopkins
MVP
Jan 17, 2021

I think you'd need to add a conditional formatting switch

So in A1 type the word "Print View?", in B1 Type Yes
Then highlight your blue cells and go to Home > Conditional Formatting > New Rule > Using a formula =$B$1="Yes" and chose a Black or White background with White or Black font

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Jan 28, 2021

    Hi Sameer_Kuppanath_Sultan 

     

    My suggestion was to toggle the setting prior to clicking print.

     

    Potentially you could use a Macro to automate it changing, printing, changing back

     

    I can't see how else it would be possible

      • Wyn Hopkins's avatar
        Wyn Hopkins
        MVP
        Jan 31, 2021

        Sameer_Kuppanath_Sultan 

         

        Something like this

         

        Sub MyPrint()

 Application.ScreenUpdating = True

 Range("Switch").Value = "Printing"   ' where Switch is a named cell that your Conditional formatting is linked to
 
 Application.Calculate
  
  
 Range("MyPrintRange").PrintOut Preview:=True   'where MyPrintRange is a named range you've created for your print area

 Range("Switch").Value = "Not Printing"
 

 
End Sub

Resources