LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
TLC TLC is offline
external usenet poster
 
Posts: 23
Default EXCEL 2003*FORMULA TO HILIGHT SPECIFIC CELLS WITH TRUE RESULTS?

Hi,
Does anyone know if there is a formula I can add into a formula already
written that will highlight the cells that return true results and the
primary formula cell too?

When the below formula, located in cell B24, returns the true value, I want
it to highlight itself and each of the referenced cells causing the true
value.

=IF(OR(B190.5,B200.5,B210.5,B230.5),"QUOTE IN MD OVER .500""",0)
Any help would be wonderful.
--
Ever so greatful,
tlc

 
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
Hide data in specific rows/colums/cells in Excel 2003 Ben Excel Discussion (Misc queries) 3 October 21st 07 04:33 PM
Return Formula results to specific row of matched criteria Sam via OfficeKB.com Excel Worksheet Functions 3 September 10th 07 11:08 PM
Excel 2003 :Summing specific cells of a particular color in a colu FLYNNE Excel Discussion (Misc queries) 2 August 18th 06 10:50 PM
View formula results instead of formula in 2003 version? Felicia Pickett Excel Discussion (Misc queries) 2 September 14th 05 12:14 AM
How do I have a IF AND formula read 2 different cells to be true parkmac Excel Worksheet Functions 2 August 4th 05 06:12 PM


All times are GMT +1. The time now is 01:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"