Hello Everyone,
I have a situation in excel while work allocation and I am in a need of help from you all excels masters. Please help based on below conditions.
- I have two sheets (sheet1) & (sheet2)
- In (sheet1) I have data in column (B,C,D,E)
- On (sheet2) I have data in four columns (A,B,C,D)
Output require is based on data available on "sheet2" I want to highlight cell colors on "sheet1"
(Condition-I: if "sheet2" value on column (A) is available on "sheet1" column (B) then highlight in (Red color)
(Condition-II: if "sheet2" value on column (B) is available on "sheet1" column (B) then highlight in (Blue color)
(Condition-III: if "sheet2" value on column (A) is available on "sheet1" column (B) then highlight in (Green color)
(Condition-IV: if "sheet2" value on column (A) is available on "sheet1" column (B) then highlight in (Orange color)
Please help!!
Thanks in advance!
I have a situation in excel while work allocation and I am in a need of help from you all excels masters. Please help based on below conditions.
- I have two sheets (sheet1) & (sheet2)
- In (sheet1) I have data in column (B,C,D,E)
- On (sheet2) I have data in four columns (A,B,C,D)
Output require is based on data available on "sheet2" I want to highlight cell colors on "sheet1"
(Condition-I: if "sheet2" value on column (A) is available on "sheet1" column (B) then highlight in (Red color)
(Condition-II: if "sheet2" value on column (B) is available on "sheet1" column (B) then highlight in (Blue color)
(Condition-III: if "sheet2" value on column (A) is available on "sheet1" column (B) then highlight in (Green color)
(Condition-IV: if "sheet2" value on column (A) is available on "sheet1" column (B) then highlight in (Orange color)
Please help!!
Thanks in advance!