- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel Help with "Conditional Formatting"
Posted on 10/5/20 at 9:22 am
Posted on 10/5/20 at 9:22 am
I'm aware how to conditionally format certain cells based on "specific values" contained therein...
But is there a way to conditionally format a cell that has ANYTHING in it if the values change? Or would I have to do something in VBA and list all possible values with an "=IF(OR(" function?
TIA.
But is there a way to conditionally format a cell that has ANYTHING in it if the values change? Or would I have to do something in VBA and list all possible values with an "=IF(OR(" function?
TIA.
2
Posted on 10/5/20 at 9:29 am to yankeeundercover
What specific action/calculation/refresh are you performing that would change the value of the cell(s)?
This post was edited on 10/5/20 at 9:31 am
Posted on 10/5/20 at 9:39 am to castorinho
I'm trying to make a conditional statement that will populate certain cells on one sheet with values from a "Data1" sheet in the workbook based on the dropdown selection on another sheet and preserve the background/cell color/etc.
So if I choose "Yes" on a dropdown, a bunch of columns/rows will be transposed correctly from a "Data" sheet and preserve the coloring and also the values from those cells... because there will be certain "pasted" cells with the "Yes" from the dropdown that will populate with information from other areas of the workbook...
For instance, If I choose "Yes", a row of headers and values below will show up as visible and the values underneath those headers will pull the data from another area of the workbook.
I apologize if I'm not making sense... but thanks for your help.
So if I choose "Yes" on a dropdown, a bunch of columns/rows will be transposed correctly from a "Data" sheet and preserve the coloring and also the values from those cells... because there will be certain "pasted" cells with the "Yes" from the dropdown that will populate with information from other areas of the workbook...
For instance, If I choose "Yes", a row of headers and values below will show up as visible and the values underneath those headers will pull the data from another area of the workbook.
I apologize if I'm not making sense... but thanks for your help.
Posted on 10/5/20 at 9:56 am to yankeeundercover
OK, your OP made it sound like you wanted a visual of cells which values changed after performing an action.
But your second post makes it sound like you just want that formatting to carry over from the cell it's reading.
So would need to clarification on whish one
But your second post makes it sound like you just want that formatting to carry over from the cell it's reading.
So would need to clarification on whish one
Posted on 10/5/20 at 12:14 pm to castorinho
I’m able to carry over the formatting from the Data sheet, but when I turn off the toggle dropdown, the color formatting persists in the cells, but just without the values and I’m trying to clear everything, including the background colors/etc.
Posted on 10/6/20 at 4:41 pm to yankeeundercover
Your question makes my brain hurt 
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News