View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andyb Andyb is offline
external usenet poster
 
Posts: 28
Default Conditional format of range

Data is input in to cell E57.
A percentage is calculated, based on the input and returned to cell E58.

I used CF to compare this with cell E29
=$E$58$E$29
If the result is above that of E29, E58 turns red.

What I want to do is turn E58 yellow if the result is up to 10 below E29.

What I mean is if cell E29 = 100
E58 100 turn red
E58 is 90 to 99 turn yellow
E58 < 90 no format