Forum Discussion
Highlighting any cell with 'X'(text) based on a cells value in corresponding row
Hey guys, I made a little manual schedule-planning sheet - but for it not to be too confusing I would like to make any cell (task) marked with X (or any text) to be coloured according to the "Resp...
Another user on another site helped me, in case anyone is wondering, here is the solution;
=AND(EU6<>"",$B6="NISOG") - pink
etc.
Works!