If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Cell Formatting
I am trying to point the conditions of 'conditional
formatting' to a formula in another cell. Is there an easy way to do this? |
#2
|
|||
|
|||
On Wed, 25 Aug 2004 12:14:05 -0700,
wrote: I am trying to point the conditions of 'conditional formatting' to a formula in another cell. Is there an easy way to do this? Use that same formula in the Formula Is: option Or use a formula of the type: =Desired_Value = Another_Cell_ref In other words, if you want to have C1 turn green if A1 = 23, Conditionally Format C1 and use Formula Is: =A1=23 --ron |
#3
|
|||
|
|||
Hi
if you want to make for example cell A1 dependent from the result in cell B1 try the following: - select cell A1 - goto the conditional format dialog - enter a formula such as: =B10 -- Regards Frank Kabel Frankfurt, Germany wrote: I am trying to point the conditions of 'conditional formatting' to a formula in another cell. Is there an easy way to do this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Cell Formatting | Andrew Mackenzie | General Discussion | 9 | July 23rd, 2004 04:06 PM |
Conditional Formatting Questions | Andy B | Worksheet Functions | 1 | May 12th, 2004 02:48 PM |
Conditional Formatting to hide contents of cell | Paul | Worksheet Functions | 0 | January 16th, 2004 12:52 PM |
Freezing Conditional Formatting | Ashish Chamaria | Worksheet Functions | 3 | December 19th, 2003 11:54 AM |
Conditional Formating on value of cell and prev cell | Phillips | Worksheet Functions | 2 | December 4th, 2003 12:27 AM |