Format a cell based on value of another cell

[jrisebo]

Lets say A1-A100 have values (but not every cell) how do a write a formula so that corresponding cell in B1-B100 is filled in with a color?

For example, it A20 value is 14, I want B20 to be yellow, and so on.

I need a formula so I can then copy it to like 40 columns I am trying to make this work on.

Thanks

 

[Fluff]

You will need conditional formatting or a macro for this. An in cell formula cannot alter the format.
In Cf you could use this formula
=$A1=14

 

[jrisebo]

You will need conditional formatting or a macro for this. An in cell formula cannot alter the format.
In Cf you could use this formula
=$A1=14

Ok, thanks. My values change so I cant do an exact formula. I didnt know if there was a formula that works like "If that cell has text, then make this cell yellow" but then be able to be drug down a column so the row changes.

 

[Fluff]

What range do you want this to work on?

 

[jrisebo]

I want it to look in cells A1-A100, and then in B1-B100 color those cells yellow based on the cells in A1 having a value. It can be random, and they can change whether or not they have a value. I forgot to mention, B1-B100 already have a formula in them. This is check.

 

[Fluff]

In that case select B1:B100, on the Home tab select Conditional Format > New rule > Use a formula > =$A1<>"" select format > Ok