A customer gave us a monthly forecast. I want to check the forecast number against historical data. Is there a formula to have excel check a row of cells and highlight the cells that were higher than the forecast in green and if they were lower to red and ignore the ones that are equal to the forecast. I tried to use conditional formatting but it seems to be for one cell not 12 as i want to check the sales in each of the last 12 months and have each one show one of the required colors. Thank you
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Checking cells against forecast
- Thread starter DocRogers
- Start date
Excel Facts
Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Similar threads
- Question
- Question
