mthornburg
New Member
- Joined
- Jun 11, 2008
- Messages
- 8
Hi. I have conditional formatting set up so that when the value of a certain cell is TRUE, a range of cells elsewhere on the sheet grays out. It works, except for the fact that when it grays out, it only changes the first cell in the range and leaves the others the same color.
I read that you can use "Paste Special" and paste the formatting of that particular cell to others. I tried that. However, the problem is that that particular cell is in large font. Thus, when the format is transferred to other cells, they all become large as well.
Is there a way around this/a more efficient way to change a range of cells conditionally? I wish there were section breaks in Excel...
I read that you can use "Paste Special" and paste the formatting of that particular cell to others. I tried that. However, the problem is that that particular cell is in large font. Thus, when the format is transferred to other cells, they all become large as well.
Is there a way around this/a more efficient way to change a range of cells conditionally? I wish there were section breaks in Excel...