Forum Discussion
Solved
Conditional Formatting using both current and adjacent cells
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!!!
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
- 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!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
Perfect - that's worked!! Thank you so much, Sergei!
Tom
