Highlighting rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
Back
Top