Hi All, I'm having a little trouble with conditional formatting and any help would be appreciated.
I currently have 4 columns of data (columns A, B, C, D). These 4 columns are followed by 4 more columns that relate to the first four (E, F, G, H). For example: column A relates to column E, column B relates to column F, column C relates to column G and finally column D relates to H. So Cell A6 relates to the cell four cells to the right, E6. If E6 has value =1 then A6 gets colored blue. I need to do this for all four columns (A-D).
I am currently putting conditional formatting in phpexcel so that would be the best way, although I am running a macro after the data is in excel so I can also make this condition in VBA macro. Thanks,
Parker
I currently have 4 columns of data (columns A, B, C, D). These 4 columns are followed by 4 more columns that relate to the first four (E, F, G, H). For example: column A relates to column E, column B relates to column F, column C relates to column G and finally column D relates to H. So Cell A6 relates to the cell four cells to the right, E6. If E6 has value =1 then A6 gets colored blue. I need to do this for all four columns (A-D).
I am currently putting conditional formatting in phpexcel so that would be the best way, although I am running a macro after the data is in excel so I can also make this condition in VBA macro. Thanks,
Parker