Excel conditional formatting row color

 Blocked Profile -

Column A indicates what type of transaction I've made (ie POS/ATM/CASH/Bill Pay) Column D is the date the transaction has cleared my bank. I want a POS to be one color an ATM to be another color once they are cleared. If they are not clear I want them to remain with no fill.

1 reply


Please, bare in mind that Kioskea is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Therefore, it is specifically requested from Kioskea forum users correspond showing mutual respect. Therefore, when requesting assistance, the use of polite expressions,as for elsewhere in similar circumstances, is appreciated. (please, thank you, appreciate, grateful, etc.)


Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month