Advanced Cell or Text formatting help

New Contributor

Hi! Screen shot attached. I want to change the formatting of Column C (Payment due date). When a bill gets due, I would either like the fonts or the cell to change the color so that I can easily identify which bills are due . I've manually entered the Bill date and Credit Period. Payment due date is Bill date + Credit Period.

Thanks in advance :)

1 Reply

Hi Khanjan,


In Conditional formatting add new rule like this


and apply it to your entire range or only to column C