Hi guys
sorry to bother you, but I have been stuck on this particular formula for the last week, and I don’t seem to be progressing any further, and I am hoping you can help
basically there are 6 columns, within these 6 columns there is various data. The data will either be a number or –. (-) is meant to show n/a, but for reporting purposes I need it to remain (-)
what I am trying to achieve with the formula ,
1)formula searches the multiple columns, and whatever the last number is within those column highlight that particular cell
2) however only highlight the cell if it is higher than the average (which is also provided in the excel sheet) and this needs to be highlighted red
hope this is self explanatory , if you have any questions please contact me
Bookmarks