I trade the futures markets and have created an xls for back testing results.
The lines D24 through H54 (1st month) are my input fields.
I'd like to create a conditional format changing the fill color based upon:
if B24 <= B1, leave it clear or fill with white
if B24 > B1 color it light yellow
and, continue the formula to line 54.
I'm trying to color these cells once the date has passed and/or I've inserted the results.
Thanks.
Bruce
Bookmarks