I just had a request to change a formula I've had for a while to have a slightly different scope. Basically there are 4 issues I'm tracking and I need the highlighted color of a cell to change based on the number of occurrences for each specific problem. Here's the current formulas I'm using:
='Employee 1'!$E$12>4.3
=IF('Employee 1'!$E$12<4.1,IF('Employee 1'!$E$12>2.1, TRUE, FALSE), TRUE)
=IF('Employee 1'!$E$12>0.1,IF('Employee 1'!$E$12<2.05, TRUE, FALSE), TRUE)
The first is highlighted red, 2nd is highlighted orange, 3rd is highlighted green.
What I need is the cell highlighted red if E12 is greater than or equal to 5, or F12, G12 or H12 are greater than or equal to 3. Orange highlighting if E12 between 2 and 4 or F12, G12 or H12 = 2. Green if any are 1. Red > Orange > Green. Is there any way I can accomplish this or would I need to do a different conditional format for each cell? The other reason I'm asking this is because I have 'employee 1' to 'employee 40' and adding 12 specific lines of conditional formatting to 40 cells seems a bit excessive.
If anyone can help I would appreciate it!
Bookmarks