I am trying to build a spreadsheet that will track numerator / denominator and value for multiple tasks and tracked each month. I use 1 cell to identify what the current month is, and a separate tab to assign month names to numbers (January = 1, February = 2 etc.). Because forumlas exist in the cells for the months that are yet to arrive, I want them to appear blank. So I've written a conditional format that states if the current month is >= the current month to either show or not to show the data in the cell.
The Formula: '=IF(VLOOKUP($C2,MRID!$B2:$C14,2,FALSE)>=VLOOKUP(Info!O3,MRID!$B2:$C14,2,FALSE),"Show","No")'
The Conditional: =Q$1="No"
Applies to: =$F$5:$H$6
There are six cells in two rows that are being used. Row 5 cells F, G, and H are merged and centered. Row 6 cells F, G, and H are NOT merged. This give me a top cell to display the value and the lower cells to have "Num" "/" "Den".
The issue is that the "/" and "Den" are not being affected by the conditional formatting. I have attached my sample spreadsheet with everything in place. I tried everything I know, and engaged some excel savvy friends and it's still unresolved.
Any help here perhaps?
Bookmarks