Spreadsheet: 36946d1234897800-problem-with-conditional-format-poss-function-err-test
Sheet: with colors

 | AR |  | Total | BUY |  | Total | Canada |  |  |  | Total | ABCD App |  |  |  |  |  |  | Total | [NAME] |  |  |  | Total | Eshare |  |  | Total |  | "=IF(B$5:B$6="Investigating",0,1)*OR(B$5:[NAME]) |  |  |  |  |  |  | change format to RED
PCI Requirements | Investigating | Not Started |  | Investigating | Compliance Verified |  | Investigating | Not Started | Remediation Plan Pending | Waiting for Evidence of Implementation |  | False Positive | Investigating | Not Started | Remediation Plan Pending | Remediation Plan Approved | Waiting for Evidence of Implementation | Remediation Plan Implemented |  | False Positive | Investigating | Remediation Plan Pending | Waiting for Evidence of Implementation |  | Investigating | Remediation Plan Pending | Waiting for Evidence of Implementation |  |  | attempted to use THE ABOVE ON THE HEADINGS.  Hoping I could use this in the 3 conditions to change colors.  But from your note, that shouldn't work.  In fact this just turns everything 1 color, despite the range entered.
1.1.3 Requirements for a firewall at each Internet connection and between any  demilitarized zone (DMZ) and the internal network zone |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  | Then I was going to apply diff conditions to the data area.
1.1.4 Description of groups, roles, and responsibilities for logical management of network components |  |  |  | X |  |  |  |  | X |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  | X
1.1.5 Documentation and business justification for use of all services, protocols, and ports allowed, including documentation of security features implemented for those protocols considered to be insecure |  | X |  | X |  |  | X |  |  | x |  |  |  |  |  | X |  |  |  |  |  |  | x |  |  |  | x
1.1.6 Requirement to review firewall and router rule sets at least every six months | 1 |  | 1 |  |  | 1 |  |  |  |  | 1 | X |  |  |  |  |  |  | 1 |  | X |  |  | 1
1.2 Build a firewall configuration that restricts connections between untrusted networks and any system components in the cardholder data environment. |  |  |  |  | X |  |  |  |  |  |  |  |  |  | X |  |  | X |  |  |  | X
1.2.1 Restrict inbound and outbound traffic to that which is necessary for the cardholder data environment. |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  | X |  |  | 1
1.2.2 Secure and synchronize router configuration files. |  |  |  | 1
1.2.3 Install perimeter firewalls between any wireless networks and the cardholder data environment, and configure these firewalls to deny or control (if such traffic is necessary for business purposes) any traffic from the wireless environment into the cardholder data environment. |  |  |  | 1
1.3 Prohibit direct public access between the Internet and any system component in the cardholder data environment. |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | X
1.3.1 Implement a DMZ to limit inbound and outbound traffic to only protocols that are necessary for the cardholder data environment. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  | 1
1.3.2 Limit inbound Internet traffic to IP addresses within the DMZ. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  | X |  | 1
1.3.3 Do not allow any direct routes inbound or outbound for traffic between the Internet and the cardholder data environment.