Is it possible if one a cell equals, lets say "-" for another cell to be
filled with a certain color?

For example, there is a formula in A2 that produces "-" and D2:J2 fills
w/ the color black.

Is that even possible?

Thanks,


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=540139

Hi!

Try this:

Select the range D2:J2
Goto FormatConditional Formatting
Formula Is: =$A2="-"
Click the Format button
Select the Patterns tab
Select the desired color
OK out

Biff

"fastballfreddy"
<fastballfreddy.27iy2n_1147151403.4135@excelforu m-nospam.com wrote in
message news:fastballfreddy.27iy2n_1147151403.4135@excelfo rum-nospam.com...

Is it possible if one a cell equals, lets say "-" for another cell to be
filled with a certain color?

For example, there is a formula in A2 that produces "-" and D2:J2 fills
w/ the color black.

Is that even possible?

Thanks,


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile:
http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=540139

Select D2:J2

FormatCFFormula is:

=$A$2="-"

Important to have the $ signs to lock $A$2 as the trigger cell.

Format to a black pattern


Gord Dibben MS Excel MVP

On Tue, 9 May 2006 00:09:00 -0500, fastballfreddy
<fastballfreddy.27iy2n_1147151403.4135@excelforu m-nospam.com wrote:


Is it possible if one a cell equals, lets say "-" for another cell to be
filled with a certain color?

For example, there is a formula in A2 that produces "-" and D2:J2 fills
w/ the color black.

Is that even possible?

Thanks,