There is lots of stuff to do with CF when using today's date but not a for specific date entered in a cell so I was hoping someone might be able to help.
I am trying to CF a row of cells (D2:K2). These all have different dates in them. The formatting is to be based on a date in another cell (B2) - so green if before this date and red if after this date. I will then be doing the same for rows below this (D3:K3 based on B3 etc.). The dates in Column B are all different as well.
Just compare the value in the two cells, and format it based on the condition. What if the cell contain "hello"? Would you be able to turn the cell red? Use the same type of formula to compare the values! Post back if you still have hardships!
- Posts
- 3
- Registration date
- Monday December 12, 2016
- Last seen
- December 13, 2016
- Dec 13, 2016 at 06:22 AMmany thanks
- Posts
- 3
- Registration date
- Monday December 12, 2016
- Last seen
- December 13, 2016
- Dec 13, 2016 at 06:50 AM"IF(DATEVALUE,$D$2:$O$2<DATEVALUE,B2)" and formatting this for green.
and the same formula with > to be red.
but it is not working.