I have three columns that contain data.
Column A, Column B, and Column C.
Now if data for a certain column is invalid, it will contain text as follows: "N/A".
I want to color code the variation existing for the the three columns.
For example:
If on row 3, 3A contains data, 3B contains data, but 3C contains N/A, i want the color of all three cells to be blue (not text color but fill color).
If on row 4, 4A contains N/A, 4B contains N/A, and 4C contains data, I want the color of all three cells to be yellow.
and the rest of the variations as well (5A contains Data, 5B contains N/A, and 5C contains data then all three green etc... etc..)
Of course logically the condition is strictly related to the N/A, and the rest of the data can contain text and numbers if it is not N/A.
Can the color coding be placed in RGB format as well? or can I create a cell with the fill color desired as a reference (in other words a legend that I can refer to when color coding the sheet)?
Thank you, I hope I was clear enough.
Column A, Column B, and Column C.
Now if data for a certain column is invalid, it will contain text as follows: "N/A".
I want to color code the variation existing for the the three columns.
For example:
If on row 3, 3A contains data, 3B contains data, but 3C contains N/A, i want the color of all three cells to be blue (not text color but fill color).
If on row 4, 4A contains N/A, 4B contains N/A, and 4C contains data, I want the color of all three cells to be yellow.
and the rest of the variations as well (5A contains Data, 5B contains N/A, and 5C contains data then all three green etc... etc..)
Of course logically the condition is strictly related to the N/A, and the rest of the data can contain text and numbers if it is not N/A.
Can the color coding be placed in RGB format as well? or can I create a cell with the fill color desired as a reference (in other words a legend that I can refer to when color coding the sheet)?
Thank you, I hope I was clear enough.