Excel Cross Tab IF Statements for Formatting
Posted on 2007-03-22
I have a crosstab query from an access database that I am exporting to excel. I have been trying to formulate the IF clauses for all cells. My data contains the following:
Vertical Access = SOX Controls
Horitonal Access = Projects
1 = Control Tested
0 = Control Not Tested
(blank) = No Control Available
I want to run the IF statement to change a 1 to "Tested", 0 to "Not Tested" and (blank cells) to "N/A" and grey them out.
I am using the following for the cells:
Can anyone please help??