Hi,
I need to highlight cells in 5 columns based on the cell values, hope this can be done with VBA.
As shown in the attached image, the “Code” should be 1, 2, 3 or 4. For all other values, those cells needs to be highlighted in Yellow Color.
If the “Code” is 1 or 2, then the “Direction”, “Min”, “Max” and “Report” should be filled. Conditions are “Direction” must be one of E/W/N/S, if it is empty or filled with other value, then those cells needs to be highlighted in Yellow Color. “Min” and “Max” must be greater than 0(zero) but not more than 4.9. “Report” should not be empty.
If the “Code” is 3 or 4 or any other value, then the “Direction”, “Min”, “Max” and “Report” should be empty, if the cells are filled with any data, those needs to be highlighted. Min and Max can be 0 (zero).
Can we filter the rows which have at least one cell highlighted in Yellow?
I tried the conditional formatting but not much success.
Hope you can help me with this.
Thanks in advance.
I need to highlight cells in 5 columns based on the cell values, hope this can be done with VBA.
As shown in the attached image, the “Code” should be 1, 2, 3 or 4. For all other values, those cells needs to be highlighted in Yellow Color.
If the “Code” is 1 or 2, then the “Direction”, “Min”, “Max” and “Report” should be filled. Conditions are “Direction” must be one of E/W/N/S, if it is empty or filled with other value, then those cells needs to be highlighted in Yellow Color. “Min” and “Max” must be greater than 0(zero) but not more than 4.9. “Report” should not be empty.
If the “Code” is 3 or 4 or any other value, then the “Direction”, “Min”, “Max” and “Report” should be empty, if the cells are filled with any data, those needs to be highlighted. Min and Max can be 0 (zero).
Can we filter the rows which have at least one cell highlighted in Yellow?
I tried the conditional formatting but not much success.
Hope you can help me with this.
Thanks in advance.