Hi guys,
Please could you advise how I may set up the conditional formatting for a range of cells in Excel. Please see attached.
If the weight of the portfolios (A, B or C) is more than 1% than the model weight, then the corresponding cell will be highlighted as red.
E.g. Cell A3 is 2%, if any of C3:E3 is more than or equal to 3%, then the corresponding cell will be red. All 3 cells will be red in this case.
I know how to do for for one row, but I would like the same logic to be applied to all rows without setting up a conditional formula for each row (e.g. row 4 will be 4% and row 5 will be 6% for their respective rows). Imagine I have 100 rows in real life.
Many thanks guys!
Bookmarks