How to set color in excel based on condition

SHEET1

image

SHEET2

image

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

RESULT
image

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.

https://support.office.com/en-us/article/use-formulas-with-conditional-formatting-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f

Cheers

1 Like

Hey Shruti,

I think this would help you @ Conditional Formatting

Thanks