Format Cell Formulas

  • Thread starter Thread starter cassy01
  • Start date Start date
C

cassy01

i want to make the row turn yellow if is it a certain value.

i want any cell in column G to turn yellow if the cell has a value of
CA1, CA2, CA3 or CA4.

So if i type CA1 in cell G5 the whole row will turn yellow ?

Is this possible ??

Many Thanks :D
Benn
 
Use Format>Conditional Formating for that. Set the test
to "between" and then set the criteria range for the
first box to ="CA1" and the second box to="CA4", then set
the formatting you want, and hit OK. Then use the fill-
handle to copy the formatting to the remaining cells.
 
Hi Cassy,
My page on Conditional Formatting is
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Your formula will be based on the active cell.
Since you want all cells in the row to turn yellow that means
that every cell on the worksheet must have a conditional format
so you will have to select all cells.

cell G2 as the active cell and then use the Ctrl+A,
using this method to select all cells, G2 will remain the active cell..
Format, Conditional Formatting
Formula Is (from drop down):
=OR($G2="CA1",$G2="CA2",$G2="CA3",$G2= "CA4")

The $ sign with the G means that on it's row the test will be
applied to the G column. Every cell on the row will be tested
in the C.F. with that formula. The formula will adjust to each row
that is tested.

[question answered by a volunteer in Usenet groups with no connection
to ExcelForum or any other HTML interface to these newsgroups]
 
Hi

If you are happy to set a conditional format accross the hilightabl
range and to add a check flag to simplify the conditional forma
criteria check then try this.

assuming you wanted to hilight cells A5:Z5 when "CA1" is entered i
cell G5.. you could enter a check flag to indicate simply when th
hilight is required. something like the following entered in sa
cell AA5 will set AA5 to 1 if hilight required.

=IF(G1="CA1",1,IF(G1="CA2",1,IF(G1="CA3",1,IF(G1="CA4",1,0))))

then I would select A1:Z1 as an example and then format, conditiona
formatting and set condition 1 to "FORMULA IS" "=$AA1=1"
and then set your required formatting, ie - yellow pattern.

Now copy the cells A1:AA1 down as many rows as you need.
now entering CA1-4 in and G col cel will hilight the row in yellow.

I attach an example to assit with my terrible explanation,

Hope this helps.

Reg

Attachment filename: hilight line in criteria.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=41675
 
First Highlight Column G
Then pull down the Format Menu
Click on Conditional Formatting...
Ensure "Cell value is" is in the first window
Second window should be CA1
Third Window should be CA4
Click on the Format button
Touch the Pattern tab on top
Choose your shade of yellow
Hit OK
Hit OK
Voila!

Hope this helps...

Healingbear
 
Back
Top