Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting a cell based upon the contents of another cell
Hello
Can anyone tell me if it is possible to format a cell so it highlights after another cell has been populated. i.e DH10 becomes a certain colour if text is populated in DG10, the problem is there is no standard or expected text going in DG10 so the normal conditional formatting rules I know don't work. Many thanks Julie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting a cell based upon the contents of another cell
Hello
Can anyone tell me if it is possible to format a cell so it highlights after another cell has been populated. i.e DH10 becomes a certain colour if text is populated in DG10, the problem is there is no standard or expected text going in DG10 so the normal conditional formatting rules I know don't work. Many thanks Julie Try using this formula to apply CF to DH10... =LEN(DG10) -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting a cell based upon the contents of another cell
Hi Julie,
Am Wed, 31 May 2017 08:13:52 -0700 (PDT) schrieb JulieS: Can anyone tell me if it is possible to format a cell so it highlights after another cell has been populated. i.e DH10 becomes a certain colour if text is populated in DG10, the problem is there is no standard or expected text going in DG10 so the normal conditional formatting rules I know don't work. if DH10 should only change the color if DG10 is filled with text you can also try: =ISTTEXT(DG10) If you enter a numeric value in DG10, DH10 doesn't change the color. Regards Claus B. -- Windows10 Office 2016 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting a cell based upon the contents of another cell
Hi Julie,
Am Wed, 31 May 2017 18:00:11 +0200 schrieb Claus Busch: =ISTTEXT(DG10) If you enter a numeric value in DG10, DH10 doesn't change the color. sorry, forgot to translate the formula: =ISTEXT(DG10) Regards Claus B. -- Windows10 Office 2016 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting based on a cell's contents | Excel Discussion (Misc queries) | |||
Conditional Formatting - For 1 cell based on contents of any cell | Excel Discussion (Misc queries) | |||
Formatting one cell based on the contents of another | Excel Discussion (Misc queries) | |||
Formatting one cell based on the contents of another cell | Excel Worksheet Functions | |||
Formatting one cell based on the contents of another | Excel Discussion (Misc queries) |