Conditional Formatting

[Tennisguuy]

I need help with conditional formatting. I need to do conditional formatting but the condition is based on two values being true.

I have a spreadsheet where if the value in B1 is equal to "saw mill" and the value is S1 is less than 25 I want it to change the color of cell B1 to blue. I will need to do this for every value in B1:B500 and S1:S500

 

[VoG]

Select B1:B500

Go to Conditional Formatting, select Formula Is and enter the formula

=AND(B1="saw mill",S1< 25)

click the Format button, apply your format and OK your way out.

 

[T. Valko]

Select B1:B500

Go to Conditional Formatting, select Formula Is and enter the formula

=AND(B1="saw mill",S1< 25)

click the Format button, apply your format and OK your way out.

It might be a good idea to make sure S1 is not an empty cell.

=AND(B1="saw mill",S1<>"",S1< 25)

 

[VoG]

And in Excel 2007+ it is "Use a formula..."