More than 3 conditional formats

[BMD]

To add to j_smit question I have

=$B27="No"
I trun the row gray.
Now they say I need to do
=$G27="Pass" trun the text green
=$G27="pass" and =$I27={"Major","Maj"} turn to yellow
=$G27="Fail" trun it red

I'm now upto four conditions and I think excel only allows three it that ture or can I keep going and how.

Thanks,
Bruce.

 

[Von Pookie]

Hi, I split this off into a separate thread

You are correct, currently Excel only allows 3 conditional formats. For more than 3 conditions, you have to use a macro.

Would this be used on all cells in a certain range, or only row 27 (as in your example above)?

 

[BMD]

OK THEN

#If (ActiveCell.Worksheet.g3 = "Pass") Then
Run (green)

Sub green()
Range("A3:O3").Select
Selection.Font.ColorIndex = 10
End Sub

The problem is with the activecell can I just say if you type in pass it will do this and if you type in fail it will do that and it you type in pass and maj it will do another.....

Bruce.

 

[Von Pookie]

Would the text colors always change, or only change when column B="No" and the row is gray?