Answer for:

Conditional Formatting

Message 5 of 5

View entire thread
0 Votes

I believe you can do this by adding more conditions?
I think you can add upto 3 conditions from the menu.
another way to do this would be from the VB editor and just add some code an example would be on a sheet change or update you could have:

example only,
Private Sub Worksheet_SelectionChange(ByVal

Target As Range)
if range("B15).value > 1 then
Range(B16).Font.Color = vbRed
end if

End Sub

I use VB Editor all the time to sort these kind of queries but i'm used to it so its quicker for me

hope it helps