Highlight Rows
Mike.. You are the.. MAN!!! WAHOOOO
"Mike H" wrote:
Hi,
These 2 conditional formats should not conflict provided
=$E1="Pending"
Is the first CF condition. You then click ADD and enter your second condition.
See my other post about calculation
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"Napoleon Vang" wrote:
And also another problem I just discovered.. I am currently using
Tools CF =MOD(ROW(),2)=1
to alternate the row colors. and it's not allowing me to highlights the
alternate rows..
"Mike H" wrote:
Hi,
Conditional formatting. Select the row(s) to which this applies then
Format|Conditional format - Select 'Formula is' from the dropdown and enter
the formula
=$E2="Pending"
Click Format and on the 'Pattern' tab and choose yellow. OK
Note that you should change the 2 to the top row of your selection
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"Napoleon Vang" wrote:
Is there a way to program an expression close to... If cell in column E
equals string of text "Pending", select entire row and change background
color/patern to yellow?
|