theuniquenerd
New Member
- Joined
- Jun 13, 2018
- Messages
- 4
I'll try and explain my issue and what I'm looking for as best I can. If I'm not clear, please let me know.
I'm trying to figure out how to apply conditional formatting to almost "remove" the formatting if a certain condition applies.
I have a conditional formats for:
<tbody>
</tbody>
I'm trying to apply a conditional format rule that will allow the formatting to be removed only from the respective dates in columns C & D if a cell in the same row in column E is 100, ie, it's complete and the row doesn't need to be highlighted for attention purposes.
Example:
<tbody>
</tbody>
Any help would be greatly appreciated!!
I'm trying to figure out how to apply conditional formatting to almost "remove" the formatting if a certain condition applies.
I have a conditional formats for:
Rule (applied in order shown) | Format | Applies to |
Cell value <=$A$1 | Light Red Fill with Dark Red Text | $C$6:$D$9 |
Cell value between $A$2 and $B$2 | Light Red Fill with Dark Red Text | $C$6:$D$9 |
Cell value between $A$3 and $B$3 | Yellow Fill with Dark Yellow Text | $C$6:$D$9 |
Cell value between $A$4 and $B$4 | Green Fill with Dark Green Text | $C$6:$D$9 |
Cell value > 99 | Green Fill with Dark Green Text | $E$6:$E$9 |
<tbody>
</tbody>
I'm trying to apply a conditional format rule that will allow the formatting to be removed only from the respective dates in columns C & D if a cell in the same row in column E is 100, ie, it's complete and the row doesn't need to be highlighted for attention purposes.
Example:
A | B | C | D | E | |
1 | 4/1/17 | ||||
2 | 4/2/17 | 5/1/17 | |||
3 | 5/2/17 | 9/30/17 | |||
4 | 10/1/17 | 4/1/18 | |||
5 | START | COMPLT | PCT COMPLT | ||
6 | Grant Write | 9/1/16 | 4/1/17 | 100 | |
7 | Grant Review | 10/1/16 | 5/1/17 | 22 | |
8 | Grant Final | 11/1/16 | 6/1/17 | 5 | |
9 | Grant Submit | 12/1/16 | 7/1/17 | 1 |
<tbody>
</tbody>
Any help would be greatly appreciated!!