RYG balls automation

JosyL

Hi,

I went thru existing discussion but could not find my exact need. I would like to automate the RYG balls to change color based on two dates columns.

For exemple if "date issued" is blank I need a yellow ball, if "date issued is not blank but "date released" is still empty then show a red ball and finally if both date columns have information (can also be if "date released" is not empty) then its a green ball.

Can someone help me out on this formatting issue?

Thanks

Mike Andreas

You may want to check my past comments as I submitted a fairly detailed answer on exactly this topic.  Best of luck.

J. Craig Williams

Try this:

=IF(ISBLANK([date issued]23), "Yellow", IF(ISBLANK([date released]23), "Red", "Green"))

for row 23.

Craig