Change formatting of cells with IF

[officehelp]

Is there a way to change the formatting of numerous cells if one cell is a certian number?

Example
A4:U4 would change if M4 had an amount of 1, it would change to a different format is it was 2 and 3 and 4.

Thank you,

 

[VoG]

Perhaps using code. Right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "M4" Then
    Select Case Target.Value
        Case 1: Range("A4:U4").NumberFormat = "0.0"
        Case 2: Range("A4:U4").NumberFormat = "0.00"
        Case 3: Range("A4:U4").NumberFormat = "0.000"
        Case 4: Range("A4:U4").NumberFormat = "0.0000"
    End Select
End If
End Sub

Press ALT + Q then try changing the value of M4.

 

[JimJohnson]

Highlight A4:M4, go into conditional formatting.
New Rule, Use a formula to determine which cells to format.
Enter: =$M4=1 and then choose the format.
Repeat with new rules for 2, 3, 4, etc.

Copy to whatever rows as needed.

 

[officehelp]

Highlight A4:M4, go into conditional formatting.
New Rule, Use a formula to determine which cells to format.
Enter: =$M4=1 and then choose the format.
Repeat with new rules for 2, 3, 4, etc.

Copy to whatever rows as needed.

okay so this worked but how do I copy it. I am an idiot when it comes to Excel and am getting very aggrevated. But again thank you for your help
I have over 100 rows that need this formula

 

[officehelp]

anyone please

 

[JimJohnson]

Highlight A4 to U4, right-click, select Copy. Highlight the range which you want to copy, right click, Paste Special, Formats.

Also, above I wrote that you should highlight A4:M4 before doing all the conditional format stuff... that should've been A4:U4. My apologies.

 

[officehelp]

hmm thank you but that didn't work.