LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Complex conditional formatting

I have the following problem trying to set cell color based on conditional
parameters.
I have a large spreadsheet where I do a log transform to get a result.
Because of the formula, I lose the sign of the function. The columns look
like this:

Number1 Number2 Formula_Result
a l x
b m y
c n z

I want to conditionally format the cells in the Formula_Result column RED if
Number1Number2, and GREEN if Number1<Number2. I'm stuck. I can do an
individual cell, but can' figure out how to do that to the entire column.
Just to be clear the result of comparing "a" and "b" control formatting of
'x', the result of comparing "b" and "c" control formatting of "y", etc.


 
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
Complex Conditional Formating Ben A Excel Worksheet Functions 6 October 16th 08 11:05 PM
Complex Conditional PAL Excel Worksheet Functions 10 July 18th 08 08:57 PM
Complex conditional formatting [email protected] Excel Worksheet Functions 3 March 1st 07 05:44 PM
complex conditional format TUNGANA KURMA RAJU Excel Discussion (Misc queries) 6 November 3rd 05 04:53 AM
complex?? Q about Conditional formatting AngelaG Excel Worksheet Functions 0 August 18th 05 08:16 PM


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