View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default "making" a line red.

Select the whole row, and use conditional formatting, with a condition of
Formula Is, and a formula of say

=$H326

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"CR" wrote in message
...
Can I make a whole line go red, if one column gets a higner number then

26.
That one column add´s up 3 others and when it hits 27, I want it to make

the
whole line red.
Is that possible?