Conditional Formatting using both current and adjacent cells

[Tom Williams]

Vendor effort highlights in green; customer in blue, for example...Hi

I am trying to highlight cells in an Excel planning spreadsheet showing tasks and days effort for Vendor and Customer resouces.

I can highlight the "days effort" cells based on whether they have a value in them (Cell value greater than 0), however I would like to colour the days efforts cells differently, based on whether it is Customer or Vendor effort.

Example of what I would like is above.

Any ideas? Would be a HUGE help as this has kept me up for hours!!!

[#2]

Forgot to say that the formula I have been trying to use was based along the lines of: "If column D contains "vendor" and Cell value > 0 then colour it green; if column D contains "Customer" and cell value > 0 then color it blue.
Thanks again!

[#3 · Accepted solution]

Hi Tom,

Two rules in Conditional formatting applied to your entire range starting from E3(?)

=ISNUMBER(SEARCH("customer",$D3))*(E3>0)

and similar one for vendors

[#4]

Perfect - that's worked!! Thank you so much, Sergei!

Tom