Thread: Cell Formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rich Stanek Rich Stanek is offline
external usenet poster
 
Posts: 6
Default Cell Formatting

I am looking for a fomula or macro that will change the formattion of a cell
based on the result.

Example: If the actual revenue is 90% or less of the budgeted revenue then
change the cell color to red. If the actual revenue is 105% or more of the
budgeted revenue then change the cell color to blue.

Any ideas?

Thanks