View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Todd Nelson
 
Posts: n/a
Default Color Formatting

Two Questioins
1. What is the formula to use when you need cells in a column to switch text
colors if it is under a certain percentage. i.e. column "o" under 95%

2. Formula to change cell color of adjacents cells to yellow if between
0:06-0:10 seconds, red if over 0:11 seconds? ie. column c 0:07 seconds,
columns a-e = yellow.

thank you!!!