LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 70
Default Coditional Format

Guys, I'm a little unsure how to complete this one. In the example below I
am trying to format cell A1 based on 3 criteria ,,, if cell C1 is less than
80% colour A1 red, if C1 is greater than 80% but less than 90% colour A1
yellow and if C1 is greater than 90% colour A1 green .... the Red and Green I
can get using the Formula Is box in the conditional format function ,, but
how do I get the "between" to work ??


A B C
1 13% 19% 68%
 
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
Identify top 20 clients/coditional formatting relo rob Excel Worksheet Functions 5 September 5th 07 11:28 PM
Coditional Formatting? Nena Excel Discussion (Misc queries) 1 August 22nd 07 07:28 PM
Why is coditional formatting not accessable? dgams Excel Worksheet Functions 3 April 23rd 05 05:32 PM
coditional formatting John Knoke Excel Worksheet Functions 5 April 17th 05 08:21 PM
how to format excel format to text format with separator "|" in s. azlan New Users to Excel 1 January 31st 05 12:57 PM


All times are GMT +1. The time now is 02:12 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"