Conditional Formatting

[Gadave]

I am trying to figure out how to add an if statement to conditional formatting... If the value in cell B5 = "V" or "Va", then color the cell red... I can get it to work if I choose ="V" or ="Va" But i cannot get it to work for both conditions... Any ideas?

[jeffreybrown]

Try...

=OR(B5="V",B5="VA")

[Gadave]

Thank you... That worked... I have one more question.. If I need to start a new thread, I am appy to do that... Else, here goes...

This is the Formula in Colum C, for all rows, 18 thru 382...

=IF(B19="V",1,IF(B19="P",1,IF(B19="Va",0.5,IF(B19="S",1,IF(B19="Sa",0.5,IF(B19="H",1,0)))))

I need a formula that will look at a range of cells in Column B (B18:B382), The add the numbers in Column C that Match to the Number of "V" or "VA" or "S" etc.. in Colum B.
They were using CountIF, But I cannot seem to get that to work with two columns involved...

Any ideas?

[jeffreybrown]

Try this....

=SUM(IF(B18:B382={"V","P","Va","Sa","H"},C18:C382))

This is a CSE formula and must be entered with Ctrl + Shift + Enter

or non CSE

=SUMPRODUCT(SUMIF(B18:B382,{"V","P","Va","Sa","H"},C18:C382))

[Gadave]

That is amazing... Thank you...