View Single Post
  #2   Report Post  
Barb R.
 
Posts: n/a
Default

Select the cell you want to format. Choose FORMAT - Conditional Formatting
and it's pretty straightforward from there.

"carl" wrote:

Using the Conditional Format Feature, I am trying to flag changes greater
than -5% Red, changes greater than 5% Blue,
but not flag if the value in C is 0 (zero) or #N/A.

Change
A 0% 25.00% -25% Flag Red
B 0% 0.00% 0% No Flag
C 22% 25.00% -3% No Flag
D 27% 25.00% 2% No Flag
E 35% 25.00% 10% Flag Blue
F 45% 25.00% 20% Flag Blue

Thank you again. I appreciate your instruction