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

[sunilkaru]

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?

A1	B1	C1
PO20054	G020735	21-Oct-19

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

 

[Peter_SSs]

Welcome to the MrExcel board!

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

Excel Workbook
	A	B	C
1	PO20054	G020735	21-Oct-19
2	PO20055	G020736
3	PO20056	G020737	abc@def.com
4	PO20057	G020738	24-Oct-19
CF Date Blank Email

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =FIND("@",C1)	Abc
A1	2. / Formula is =C1=""	Abc
A1	3. / Formula is =AND(C1<>"",ISERROR(FIND("@",C1)))	Abc