Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,510
Default Conditional Formatting of Percentages

Had problems with previous post and now it appears to be corrupted so I'll
try again.

You can't use percentages as such in the formulas. You need to use the
decimal equivalent in the formulas. 90% = 0.9, 89% = 0.89, 80% = 0.8

Conditional format formulas. Use them in the order shown. Replace E16 with
the cell that you are testing for the value.

Green. (I have assumed you mean = 90%; not just 90%)
=E16=0.9

for Orange (I have assumed you mean = 80%; not just 80%)
=E16=0.8

For Red
=E16<0.8

--
Regards,

OssieMac


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
using percentages in conditional formatting Rolando Excel Worksheet Functions 1 May 29th 09 12:20 AM
Excel 2007 - Conditional Formatting Problem with Percentages Caros Excel Worksheet Functions 3 March 12th 09 06:47 PM
Conditional Formatting with Percentages - only 2 of 3 working Roady Excel Worksheet Functions 3 March 16th 08 11:16 PM
Apply conditional formatting to cells formatted as percentages? patgal77 New Users to Excel 1 April 18th 07 08:47 PM
Conditional Formatting and Percentages of a set target [email protected] Excel Programming 0 January 30th 07 07:05 PM


All times are GMT +1. The time now is 11:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"