CONDITIONAL FORMATTING w/if function

[SDKBRK]

I have a spreadsheet and I want a cell to change colors when it does not match my criteria.
If cell C10 = 1, cell V10 should not be over 1.2, if its over turn RED.
If cell C10 = 2, cell V10 should not be over 4.0.

I want this in cell V10 using conditional formatting.

Thanks.
di

 

[barry houdini]

What colour does it change if the second condition is satisfied. Is that red also or another colour?

 

[MNpoker]

Deleted

 

[MNpoker]

IT's not pretty but this works. I could clean it up pretty easily.

NOTE: You need to put this in the Folder: MicrosoftExcelObjects And click on the Sheet



Private Sub Worksheet_Change(ByVal Target As Range)


If Target.Address = "$C$10" Then
' First Reset to normal colors
Range("V10").Select
Selection.Font.ColorIndex = 0
Selection.Interior.ColorIndex = xlNone

'Test for conditions
' C10 = 1
If Range("C10") = 1 Then
If Range("V10") > 1.2 Then
Range("V10").Select
Selection.Font.ColorIndex = 3
End If
End If

' And another one for C10 = 2
If Range("C10") = 2 Then
If Range("V10") > 4 Then
Range("V10").Select
With Selection.Interior
.ColorIndex = 3
.Pattern = xlSolid
End With
End If
End If

End If

If Target.Address = "$V$10" Then
' First Reset to normal colors
Range("V10").Select
Selection.Font.ColorIndex = 0
Selection.Interior.ColorIndex = xlNone

'Test for conditions
' C10 = 1
If Range("C10") = 1 Then
If Range("V10") > 1.2 Then
Range("V10").Select
Selection.Font.ColorIndex = 3
End If
End If

' And another one for C10 = 2
If Range("C10") = 2 Then
If Range("V10") > 4 Then
Range("V10").Select
With Selection.Interior
.ColorIndex = 3
.Pattern = xlSolid
End With
End If
End If

End If

End Sub

 

[Yogi Anand]

I have a spreadsheet and I want a cell to change colors when it does not match my criteria.
If cell C10 = 1, cell V10 should not be over 1.2, if its over turn RED.
If cell C10 = 2, cell V10 should not be over 4.0.

I want this in cell V10 using conditional formatting.

Thanks.
di

Hi di:

One way to do this is to use the following Conditional Formatting formula in cell V10 ...

=$V$10>CHOOSE($C$10,1.2,4,valFor3,valFor4,"...")
... pattern RED

 

[SDKBRK]

It works......

Thank you so much the fomula using CHOOSE it works. It took me a few mins to figure out how it works but it works.

Thanks again
di

 

[Pekkavee]

Cool Yogi

Pekka