Cell Color

[Brad]

Thanks for taking the time to read my question.

I am editing a workbook that someone else made. There
are some cells that have coloring in them. I want to
apply the coloring to adjcent cells. When I go to the
cell properties to find the color, there is no color
applied to the cell. When I try the paste format button,
nothing is pasted.

How is the color applied to these cells?

The sheet is unprotected.

Thanks in advance,

Brad

 

[Frank Kabel]

Hi
probably a conditional format depending on the cell value. Have a look
in the menu 'Format - Conditional Format'

 

[Anne Troy]

Probably conditional formatting, Brad. Select a colored cell, and hit
Format-conditional formatting... To copy that conditional formatting to
other cells, use the format painter.
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->

 

[David McRitchie]

Might not be that simple. Heck with Conditional Formatting
nothing is simple when you want to change it.

Trying to determine what the entire area that was used when
a Conditional Formatting was applied is trial and error. Finding out
what the Conditional Formatting of a cell is is by testing individually
or with a User Defined Function to find out what is used in a cell.

The format painter is the easiest to use but be aware that it
will copy but numnber formatting and conditional formatting
and you would want to check the Conditional Format
of interest that it has a $ sign in front of the Column
Number if you want the same column to control the coloring
of the adjacent cell. Or no $ sign if the other column is to
be checked in the same manner.

My page on Conditional Formatting is
http://www.mvps.org/dmcritchie/excel/condfmt.htm

BTW if you do not find a Conditional Format for the cell
it could be changed by an event macro so also right-click
on the sheet tab then view code to see if there is an event macro.
http://www.mvps.org/dmcritchie/excel/event.htm#case

 

[Brad]

Thanks guys,

It was conditional formatting.

I have not used that very much, and forgot about it.

Thanks again,

Brad