Hi there,
Could you please help me to clour the rows contains 'ACH CREDIT' (column E) in Yellow, rows containing 'BOOK TRANSFER' in Green, and 'PAID CHECK' in Blue using conditional formatting?
Attached please find the data.
Hi there,
Could you please help me to clour the rows contains 'ACH CREDIT' (column E) in Yellow, rows containing 'BOOK TRANSFER' in Green, and 'PAID CHECK' in Blue using conditional formatting?
Attached please find the data.
What have you tried so far? This is very basic conditional formatting. Simply set up a rule so if the cells contains "ACH CREDIT" the formatting is yellow fill. Smae for the other two.
https://support.office.com/en-gb/art...5-b682c4f77ce1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks