| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Change the colour of a cell if another named cell is blank
Hi
Really hoping someone can help, been up many hours trying to sort this. Basically I want to know how to use conditional formatting for adjacent cells. i.e If cell A1 contains any text then make cell C4 blue the above is just an example and will want to format C4 to a specified colour at a later date. Very new to vba and conditional formating so please be gentle. :-) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change the colour of a cell if another named cell is blank
on 4/22/2012, LISAISAAC supposed :
Hi Really hoping someone can help, been up many hours trying to sort this. Basically I want to know how to use conditional formatting for adjacent cells. i.e If cell A1 contains any text then make cell C4 blue the above is just an example and will want to format C4 to a specified colour at a later date. Very new to vba and conditional formating so please be gentle. :-) Try... Conditional Formatting 'Formula' =$A$1<"" Set color on the Pattern tab of the Format... dialog. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change the colour of a cell if another named cell is blank
Have a look at replies to your earlier duplicate post in other news
group. Gord On Sun, 22 Apr 2012 16:00:45 +0000, LISAISAAC wrote: Hi Really hoping someone can help, been up many hours trying to sort this. Basically I want to know how to use conditional formatting for adjacent cells. i.e If cell A1 contains any text then make cell C4 blue the above is just an example and will want to format C4 to a specified colour at a later date. Very new to vba and conditional formating so please be gentle. :-) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| if cell colour is then change cell colour in range | Excel Programming | |||
| change current cell colour based on the value of adjacent cell on other worksheet | Excel Programming | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
| How can i change cell colour depending on month of date in cell? | Excel Discussion (Misc queries) | |||
Linear Mode
