Conditional Formatting

[Tennisguuy]

I need help with conditional formatting. I want excel to highlight a cell if the values to two statements are true.

For example if the value in cell B1 is equal to saw mill and the value in cell S1 is less than 25 I want excel to fill the value in cell B1 with the color of green. I will need to do this for cells in B1:B500 and S1:S500.

 

[T. Valko]

I need help with conditional formatting. I want excel to highlight a cell if the values to two statements are true.

For example if the value in cell B1 is equal to saw mill and the value in cell S1 is less than 25 I want excel to fill the value in cell B1 with the color of green. I will need to do this for cells in B1:B500 and S1:S500.

You want to apply this format to cells B1:B500, right?

What version of Excel are you using?

 

[VoG]

Duplicate http://www.mrexcel.com/forum/showthread.php?t=546423

 

[Tennisguuy]

I'm using office 2007. Yes I want to apply this formatting to cells B1:B500 only but the since this is a conditional statement cells S1:S500 have to be in the formula

 

[T. Valko]

I'm using office 2007. Yes I want to apply this formatting to cells B1:B500 only but the since this is a conditional statement cells S1:S500 have to be in the formula

You have a solution at your other thread.

 

[Tennisguuy]

Sorry about the double post but i posted the first one before going to lunch and when I did a search nothing came back so I thought the first post didnt go through so I reposted it.