Comditional Formatting Relative Recording VBA
Solved/Closed
bernei
Posts
3
Registration date
Thursday November 25, 2010
Status
Member
Last seen
November 26, 2010
-
Nov 25, 2010 at 03:09 AM
bernei Posts 3 Registration date Thursday November 25, 2010 Status Member Last seen November 26, 2010 - Nov 26, 2010 at 02:40 AM
bernei Posts 3 Registration date Thursday November 25, 2010 Status Member Last seen November 26, 2010 - Nov 26, 2010 at 02:40 AM
Related:
- Comditional Formatting Relative Recording VBA
- Vba case like - Guide
- Messenger recording download - Guide
- Audacity listen while recording - Guide
- Number to words in excel formula without vba - Guide
- How to send recording in messenger - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 25, 2010 at 04:12 AM
Nov 25, 2010 at 04:12 AM
try this
do the conditional formatting (using "the formula is") on B2 (row 1 is header row) and then copy this for ALL THE CELLS---use pastespecial-format.
do the conditional formatting (using "the formula is") on B2 (row 1 is header row) and then copy this for ALL THE CELLS---use pastespecial-format.
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 25, 2010 at 07:57 PM
Nov 25, 2010 at 07:57 PM
sorry for misunderstanding. I do not mean that you should change the formula in the cell. But you introduce the formula in "conditional formatting".
select the cell B2
click format-conditional formatting
in this window
under condition 1 choose "the formula is"
on the right side write the formula
e.g.
=B2>A2
click format in the second line of this window
format window opens
in this window choose "pattern" the right end of the choices at the top
choose color (green)
click ok
you are back in conditional formatting window
click add (at the bottom left)
in condition2 give the second formula and follow other steps (including click ok)
you are again back to conditional formatting windowa
again click add and type the third formula
repeat steps(including ok)
you are back in the conditional formatting window
now click ok in this window
check whether the original formula in B2 changed. It won't be.
you can have three conditions in conditional formatting in excel versions 2003 and before.
in excel 2007 you can have more.
now select B2 and click edit-copy (or control+c) now select all other cells from column 2 to the right and click edit-pastespecial and then choose format. click ok
the conditional formatting in the cells are created by there should not be any change in the existing formulas. you can test it by selecting any cell and click foramt -conditional formatting.
experiment in a small data.
select the cell B2
click format-conditional formatting
in this window
under condition 1 choose "the formula is"
on the right side write the formula
e.g.
=B2>A2
click format in the second line of this window
format window opens
in this window choose "pattern" the right end of the choices at the top
choose color (green)
click ok
you are back in conditional formatting window
click add (at the bottom left)
in condition2 give the second formula and follow other steps (including click ok)
you are again back to conditional formatting windowa
again click add and type the third formula
repeat steps(including ok)
you are back in the conditional formatting window
now click ok in this window
check whether the original formula in B2 changed. It won't be.
you can have three conditions in conditional formatting in excel versions 2003 and before.
in excel 2007 you can have more.
now select B2 and click edit-copy (or control+c) now select all other cells from column 2 to the right and click edit-pastespecial and then choose format. click ok
the conditional formatting in the cells are created by there should not be any change in the existing formulas. you can test it by selecting any cell and click foramt -conditional formatting.
experiment in a small data.
bernei
Posts
3
Registration date
Thursday November 25, 2010
Status
Member
Last seen
November 26, 2010
Nov 26, 2010 at 02:40 AM
Nov 26, 2010 at 02:40 AM
Ah, that's fantastic, thanks for your help!
Nov 25, 2010 at 06:33 AM