Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Conditional formatting
Posted by Bill on October 13, 1999 9:08 PM
This is probably pretty simple. I have a column that is already "conditionally formatted." Returns a simple answer based on a set of conditions...How can I highlight another column with colors or borders that has no relevance mathematically with the column in question? For example: (and I apologize)
Cell H4 has a a value of "No". Based on "=IF(F4-C4>4500,"Yes","No"). Say I'd like to highlight cell A4, in a certain way. Bold it, or change the background color if the return is "Yes". I've tried every thing I can think of w/o using VB. But there's got to be an easy way...isn't there?
Bill
Re: Conditional formatting
Posted by Chris on October 14, 1999 1:47 PM
Bill,
There is an easy way. You are going to conditionally format A4. In the conditional format dialog, change from "Cell Value is" to "Formula is." Then use a formula like the following:
=IF(H4="YES",TRUE,FALSE)
Choose the conditional formatting that you want, and you're done.
HTH,
Chris
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.