I would like to pull the condense of a cell on one work sheet and apply it to another sheet based on if it is highlighted with conditional formatting?
so if cells B5-B37 has a list of names and the cells have a conditional formatting of:
=SUMPRODUCT(($H$4:$KZ$4=TODAY())*(($H5:$KZ5="IN")+($H5:$KZ5="OUT")+($H5:$KZ5=1))) (Thanks again AlphaFrog)
Which automatically updates daily, I would like all the cells that apply to this (which are highlighted green) to automatically generate to a different sheet column B rows 5 and down.
Thanks
so if cells B5-B37 has a list of names and the cells have a conditional formatting of:
=SUMPRODUCT(($H$4:$KZ$4=TODAY())*(($H5:$KZ5="IN")+($H5:$KZ5="OUT")+($H5:$KZ5=1))) (Thanks again AlphaFrog)
Which automatically updates daily, I would like all the cells that apply to this (which are highlighted green) to automatically generate to a different sheet column B rows 5 and down.
Thanks