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 https://support.office.com/en-us/article/use-formulas-with-conditional-formatting-fed60dfa-1d3f-4e13... add new rule like this

Due01.JPG

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

Due02.JPG