Print - Change Cells Fill Colour?

Hello All.

I have set up a spreadsheet to print preview via an assigned command Button.
Many thanks to Warship for helping me with the formula as I didn't know how to do it.
My formula now is;
Code:

    Private Sub CommandButton4_Click()
    'Print Summary
    ActiveSheet.PrintPreview False
    End Sub

My problem is this.
The printed range is Q1:AZ43.
But most of the cells fill colour in this print range are Black :-(
So for printing this is a real pain.

Is there a way in VBA to say;
"If any cell in the range Q1:AZ43 is filled with black, change it to white for printing.
&
If any font in the range Q1:AZ43 is white, change this to black for printing.

That's it! That's my question, & headache! :-)
I really don't know if this is possible. But if it is, and someone knows how this could be
achieved, please can someone advise, as I really don't know how to do it.
My VBA skills are quite low,
(Actually very low :-()
As a note, I did try to google for solutions,, I know the following is very very wrong,,
but it might help. I came up with;
Code:

    Private Sub CommandButton4_Click()
    'Print Summary
    ActiveSheet.PrintPreview False

    Range("Q1:AZ43").Interior.Color = RGB(255,255,255)
    Change to:Range("Q1:AZ43").Interior.Color = RGB(0,0,0), TO PRINT ONLY

    Range("Q1:AZ43").Font = RGB(0,0,0)
    Change to:Range("Q1:AZ43").Font = RGB(255,255,255), TO PRINT ONLY
    End Sub

Again,, I know it's wrong,, but hey,, I did try to get the essence of it right (I think)

I hope somebody can crack it for me.
It's pretty much the last piece in the puzzle of my spreadsheet.
I hope someone can fathom out a solution.

Many thanks to you all
TheGhost
PS as a note & for cross posting purposes I did try & post this 1st on MrExce.
But something strange happened & it posted it only as a print preview?
I'm waiting for a moderator to tell me why this happened :-(