LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to change cell color with reference to a formula?

I want to change the color of a cell with conditional formatting.That means
the
cell color Value
Red 0-97
Yellow 97.01-99.99
Green 100
White the cell is blank
The problem is in conditional formatting we can use only 3 formulas.So how
to do it?
 
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
Cell color index formula reference instead of =counta Mr. m0le[_2_] Excel Discussion (Misc queries) 0 July 30th 09 02:13 AM
change cell color within a formula... rdeap Excel Discussion (Misc queries) 4 August 8th 07 07:14 PM
How to change a tab name with cell reference and formula? Jared Excel Worksheet Functions 3 June 12th 06 09:41 PM
Change color in cell if contains formula? Wind54Surfer Excel Discussion (Misc queries) 8 July 17th 05 11:40 PM
text color change in cell reference TomKat743 Excel Discussion (Misc queries) 3 June 16th 05 12:38 AM


All times are GMT +1. The time now is 05:27 PM.

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"