Questions

Using Conditional Formatting in Excel with different results

Tags: Windows, Community
+
1 Votes

Using Conditional Formatting in Excel with different results

PterNovice
Hi,
Here is the sample data where the conditional formatting requirement will be based:
STATUS DOCUMENT
1 A
2 B
3 C
4 A
5 D
2 D
5 E
Requirements:
Color cells in Document column (say blue) IF status ISNOT 4 OR 5 AND a "duplicate record" in the same column ELSE color data row (say green) if Status=4 OR Status=5.
I tried but I face a wall and make up the formula to use in the conditional formatting. I would really apreciate any assistance. Thanks.

Member Answers