can you make a macro automatially fill a cell with a certain colour?

[manaz]

Can anyone tell me if you can write a macro to inset a certain colour (fill) into a row of information once a specific cell has an entry entered (ie is not blank)

Cheers

 

[dave3009]

Re: can yo make a macro automatially fill a cell with a certain colour?

Yes

Not by macro but by Conditional Formatting highlight the cell you wish to highlight then use Format>>Condition Formatting>>Formula Is: =A1=""

Given A1 is the blank cell you refer to

EDIT: Yes a Macro can do it but try the built-in function first

 

[manaz]

thats great thanks, but can you make it fill the row that the specific cell is in, i.e. cell N3 has text in it and yo want to highlight fom column A3 to N3?

 

[Smitty]

Welcome to the Board!

Sure,

Just select A3:Nxx for as many rows as you want to apply the formatting and use =$N3<>"" (note the $)

HTH,

 

[manaz]

thanks that worked perfect, but i would like it to apply to a whole sheet, so every cell in column 'N' that has text in it is highlighted from column 'A' to 'L'.

 

[Smitty]

Select column A then hold down the Shift key, End Key + Down Arrow key, then still holding down the shift key use the right arrow key until you get to N. Then open Conditional Formatting and apply your formula.

Or use the mouse to select the columns.