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: 77
Default Conditional formating

Hi
I must be doing something wrong.

I have a large spreadsheet which I have use a conditional format...some line
work ok but other do NOT

For example

In Col B I have 58.05
In Col C I have 8
In col D I divide Col B by Col c and get 7.26

The same occurs in Col F I have 9 and in Col G I have 1:Then I divide Col F
by Col G and get 9 in col H
I have formatted COL H as follows:
Cell value greater than or equal to col D...........make it GREEN
Cell value less than COL D.............make it RED
In this case the color is GREEN and It should be red, Most other lines are
OK but not all
I need help...please
and Thanks
Norton Professional 2004 says this email is clean...believe 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
Conditional Formating Donna Excel Discussion (Misc queries) 4 June 3rd 09 10:26 AM
Conditional formating Renee Cole Excel Discussion (Misc queries) 5 September 14th 08 09:30 AM
conditional formating Paul Excel Discussion (Misc queries) 1 March 31st 08 10:36 AM
Install dates formating using conditional formating? Jerry Eggleston Excel Discussion (Misc queries) 2 November 9th 05 05:49 PM
conditional formating souris75 Excel Programming 3 February 25th 04 08:04 PM


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