Any way to test whether rows are empty or contain the word Pass ?

  • Thread starter Thread starter rCube
  • Start date Start date
R

rCube

Excel 2003
c d e f g h
3 pass pass pass
4
5
6 pass pass
7
8 pass pass

If ranges c3:h3 to range c55:h55 have rows like 4 ,5 and 7 that are blank,
then shade them in light blue
 
1. Select the cell/Range (say C3:H55). Please note that the cell reference C3
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=COUNTA($C3:$H3)=0

4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK

PS: If you are using XL2007 Goto Home tab>Styles>Conditional
Formatting>Manage rules>New rule>Use a formula to determine which cells to
format. Enter the formula in the box below.
 
Back
Top