How to set color in excel based on condition

excel
activities

#1

SHEET1

image

SHEET2

image

IF VALUE IS SAME I NEED TO SET GREEN IF WRONG RED

RESULT
image


#2

Hi,

For my part I would simply format the workbook previously before adding the data with the excel conditional formatting feature

You can find info about it here.

Cheers


#3

Hey Shruti,

I think this would help you @ Conditional Formatting

Thanks