Here is what I have ...
I have 3 CF's in Column G:
=AI577>14 turn cell red
=AI577=0 no color
=AL577>14 turn cell red
Cell AL577 is populated but the following IF Statement:
=IF(G577="",$AK$1-E577,0)
For the purpose of testing ...
G577 is blank
AK1 has a date of 12/06/19
E577 has a date of 12/06/04
So AL577 is 15
Cell G577 is not turning red ?
The first 2 CF work ... the 3rd not so much?
Thoughts?
Bookmarks