Need Help with Conditional Formatting Hghlight in Excel

Dear Excel forum member's

I want to higlight wiith conditionl farmete when i enter bill paying amount need to highlight status cell PAID or DUE ( for example i paid may-2019 amout ) same like next month when paid need to highligt cell

Thanks

Data Sheet Attached

Utility Bill Pay Check List.xlsx

Originally Posted by alansidman

Attachment 626139 See attached.

invalid attachment link not oppen

Originally Posted by alansidman

Tried again. Seems to work this time. Thanks for letting me know.

Thanks i haven't understad how to insert farmula could you please you can insert farmula in excel sheet then re-attached.

Originally Posted by alansidman

Attached as requested.

Also a tutorial from Google Search https://support.office.com/en-us/art...b-f1951ff89d7f

Thanks i have tryed but there is no funcion PAID,DUE i have enter amout also help me please

Originally Posted by alansidman

I have no idea what you are saying here. It makes no sense to me. The tutorial is very clear on how to do conditional formatting.

sorry for disturb you what i mean to say if add amount month of may in cell no (K8) then cell no (S8) need to hight PAID
same like cell no (K10) there is no amount it meant DUE this one aslo need to highlight ( if i add amout highlit to paid if i no add amout that aslo hight lidt due)