Change the colour of a cell if another named cell is blank

L

LISAISAAC

Hi
Really hoping someone can help, been up many hours trying to sor
this.
Basically I want to know how to use conditional formatting for adjacen
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 specifie
colour at a later date. Very new to vba and conditional formating s
please be gentle.

:-
 
G

GS

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.

:)
Click to expand...

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
 
G

Gord Dibben

Have a look at replies to your earlier duplicate post in other news
group.

Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional formating in adjacent cells 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
conditional formating If A1 or B1 is blank then C1 (Font Colour Ch 7
Format a blank cell based on the value of another cell 2
How to make a cell copy the fill colour of another cell 1
Copying the colour of one cell to anothers. 0
Cell colour change if formula displays false 3
Formatting a cell with colour based on whether another cell's valu 1

Top