I want to Highlight "X" cells per the value of a cell within each row, however, I need this to function on a per-row basis and to add there are up to 5 different options that the highlighted cells can be arranged.
So far I have written 2 formulas in the conditional format "=IF($H3="Square Bar",$I3)" and "=IF($H$3="Plate/Sheet",$I$3)". The way I see it is I would have to write this formula for all 5 options per row and I have 15 rows Minimum.
Is there a way to create a formula that would work for all 15 rows (per row) and work with all 5 options without having to create this over and over again?
Thanks,
Scott
So far I have written 2 formulas in the conditional format "=IF($H3="Square Bar",$I3)" and "=IF($H$3="Plate/Sheet",$I$3)". The way I see it is I would have to write this formula for all 5 options per row and I have 15 rows Minimum.
Is there a way to create a formula that would work for all 15 rows (per row) and work with all 5 options without having to create this over and over again?
Thanks,
Scott