VBA Conditional Formatting

[Mudbutt]

I need to conditionally format each cell in Column F to fill interior blue if the corresponding cell in Column B contains text "WIP". How do I reference another column in conditional formatting?

 

[Weaver]

you need to use the 'formula' option from the lefthand list box.

Say your data (and therefore your selection) of column F starts on row 2

=$B2="WIP"

would be the formula.

HTH

 

[Mudbutt]

It needs to contain the word "WIP" though, it's not exclusively "WIP". How do i do that? I tried to do the same thing with "*WIP*" and it didn't work.

 

[Weaver]

If you need it to be case sensitive

=NOT(ISERROR(FIND("WIP",$A2)))

if not, then

=NOT(ISERROR(SEARCH("WIP",$A2)))

HTH