Advanced Cell or Text formatting help

Question

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 :)

sergeibaklan · Answer

Hi Khanjan,
&nbsp;
In Conditional formatting&nbsp;https://support.office.com/en-us/article/use-formulas-with-conditional-formatting-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f add new rule like this

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

&nbsp;

Forum Discussion

Advanced Cell or Text formatting help

Share

Resources