conditional formatting rows depending on a column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

news.microsoft.com - 01 Apr 2008 13:06 GMT

how to conditional format a n*m box depending a column value
for example I have 4*3 box and I want to highlight the row depenidng the
third column value.
a,f,3
a,b,4
x,y,5
x,a,1

the formula for conditional formatting is "=c1>3" and I choose color.
and apply to $A$1:$C$4
You might expect only C column is colored.
How can I color the A and B column?
I don't want to use VBA.

Reply to this Message

Bob Phillips - 01 Apr 2008 14:01 GMT

Select all columns and use

=$C1>3

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> how to conditional format a n*m box depending a column value
> for example I have 4*3 box and I want to highlight the row depenidng the
[quoted text clipped - 9 lines]
> How can I color the A and B column?
> I don't want to use VBA.

Reply to this Message

news.microsoft.com - 03 Apr 2008 08:22 GMT

thanks so much.

Bob Phillips 쓴 글:

> Select all columns and use
>
> =$C1>3

Reply to this Message

Rate this thread: