Custom Format Question

[Guest]

Is it possible for me to custom format an entire row to turn red (Fill) if a
specific cell in that row 'contains' a certain word? Thanks for any help!

 

[Bernard Liengme]

I will assume the first row is 2 and the "word" is in column F
Use the mouse to select all the rows (do this by dragging over the row
numbers at the far left)
Use Format | Conditional Formatting and specify:
Formula Is: =$F2="word" (the $ is important!) ; then click the Format
button and use either a red font or a red pattern as required
best wishes

 

[JE McGimpsey]

Not Custom format, but you can use conditional formatting.

Select the row (say row 1). Choose Format/Conditional Formatting...

Change the dropdown/inputboxes to read

CF1: Formula is =COUNTIF($A1,"*certainword*")
Format1: <patterns>/<red>

 

[Guest]

Go to Format> Conditional formatting...

There you can select the option "Cell Value Is", then "Equal to", and there
you write the text that must be typed in order to turn it red, click the
button "Format" and there select the color you need on the "Patterns" tab

 

[Bob I]

Conditional Formatting. Select entire row, then format, conditional
formatting, use Formula is.

 

[Guest]

one more for conditional formatting!

 

[Guest]

Thank you all for your responses! Very helpful. Bernard's worked great for a
specific word but I used the solution provided by JE since it worked where
the cell 'contains' the word.
Can I make this formula look atb multiple columns? Say for instance check
column
E and if the word is found there fill with red, check column F and if found
there fill with Yellow, Check column G and if found there fill with Green?

 

[JE McGimpsey]

Add a second and third condition in the Format/Conditional formatting...
dialog

 

[Guest]

I found that I can check up to 3 columns using the conditional format,
obviously wasn't thinking. My original thought was trying to set a custom
format as opposed to the conditional format. I have seen custom formats which
can set a fill color of a cell based on the value of another cell. Perhaps
there is a way to accomplish this using a custom format which could extend
beyond 3 checks?

 

[Bob I]

Please fix your tag line. Re:
If you're reading it in english, thank a Veteran!



I found that I can check up to 3 columns using the conditional format,
obviously wasn't thinking. My original thought was trying to set a custom
format as opposed to the conditional format. I have seen custom formats
which
can set a fill color of a cell based on the value of another cell. Perhaps
there is a way to accomplish this using a custom format which could extend
beyond 3 checks?

 

[Gord Dibben]

There is no custom format to change the background color of a cell based on any
condition.

CF is it...........if you need more than the 3 you can use VBA, Excel 2007 or
Bob Phillips' CFPlus add-in which allows up to 30 conditions.

http://www.xldynamic.com/source/xld.CFPlus.Download.html


Gord Dibben MS Excel MVP

 

[JE McGimpsey]

No, you haven't. XL doesn't have that capability.

You CAN use Custom Format to change the FONT color based on the numeric
value of the cell, but not the fill color.