View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Chg row color if certain criteria is met

check out conditional formatting in help
Format-conditional format-formula is =cell=100%

"Suddz62" wrote:

How do I make my worksheet chg the row color to a specific color if a cell
equals 100%, but if the cell is between 1 - 99% chg the row color to a
different color.
--
Thx for your help!