Highlighting rows

E

eagle's claw

Is it possible to highlight an entire row in Excel using one of the cells as the "trigger?" I have a excel sheet that I am using that has many different fields. I need the entire row to change color is on of the fields is blank or doesn't meet specific creteria. Basically, I want to flag the entire row. If not, can one cell's color be changed if another one is blank or missing the appropriate information? Any help is appreciated.
 
F

Frank Kabel

Hi
you can do this using conditional format. E.g. you want to highlight
the rows in which column A is blank. Try the following:
- select all rows for which you want to apply this highlighting
(assumption: you start in row 1)
- Goto 'Format - conditional format'
- Enter the following formula: =$A1=""
- Choose your format

HTH
Frank
 
R

RagDyer

This page of Chip Pearson's might be just what you're looking for:


http://www.cpearson.com/excel/RowLiner.htm
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Is it possible to highlight an entire row in Excel using one of the cells as
the "trigger?" I have a excel sheet that I am using that has many different
fields. I need the entire row to change color is on of the fields is blank
or doesn't meet specific creteria. Basically, I want to flag the entire
row. If not, can one cell's color be changed if another one is blank or
missing the appropriate information? Any help is appreciated.
 
Top