Forum Discussion
Solved
Conditional Formatting using both current and adjacent cells
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 ...
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
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