VBA Changing interior color based on value of another cell in same row

sunilkaru

New Member
Joined
Oct 22, 2019
Messages
1
Dear All

i have a data base and i need to change back ground color of a cell based on value of another cell in the same row. for an example, how to change color of A1 , if C1 got a date value (only type of value)? other types are email and blank. so I need to change 3 different colors?

A1B1C1
PO20054G02073521-Oct-19

<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
42,747
Office Version
365
Platform
Windows
Welcome to the MrExcel board!

Do you really need VBA? Could you just use Conditional formatting like this?

Excel Workbook
ABC
1PO20054G02073521-Oct-19
2PO20055G020736
3PO20056G020737abc@def.com
4PO20057G02073824-Oct-19
CF Date Blank Email
#VALUE!
 
Last edited:

Forum statistics

Threads
1,085,995
Messages
5,387,152
Members
402,045
Latest member
Hidalgo

Some videos you may like

This Week's Hot Topics

Top