JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 582
- Office Version
- 365
- Platform
- Windows
I think I already know the answer to this but I figured I would ask.
I have a table. 5 columns, 25 rows. (A1:E25) there is particular alpha data in the table
I have a matching table below it with numbers that will vary (A30:E55) depending on the number say in cell A30
(>10) for example) I want to fill the corresponding cell in the above table (A1) with a color if the cell A30 is >10 than no fill. I accomplished this using the Conditional Formatting for that 1 cell.
Question. Do I need to do a Conditional Formatting for each of the 125 cells in the upper table? Is there a way to duplicate the same formula but have it correspond to the correct cell from the below table?
A30 = A1
A31 = A2
B33 = B3...
...E25 = E55
I am thinking I will need to add the formatting to each cell but like I said, just checking.
Thank you,
James
I have a table. 5 columns, 25 rows. (A1:E25) there is particular alpha data in the table
I have a matching table below it with numbers that will vary (A30:E55) depending on the number say in cell A30
(>10) for example) I want to fill the corresponding cell in the above table (A1) with a color if the cell A30 is >10 than no fill. I accomplished this using the Conditional Formatting for that 1 cell.
Question. Do I need to do a Conditional Formatting for each of the 125 cells in the upper table? Is there a way to duplicate the same formula but have it correspond to the correct cell from the below table?
A30 = A1
A31 = A2
B33 = B3...
...E25 = E55
I am thinking I will need to add the formatting to each cell but like I said, just checking.
Thank you,
James