Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
David
 
Posts: n/a
Default change cell color after comparison to a value

I have a spreadsheet that has 6 columns. Column 1 and 2 are just
identifiers. Column 3 has a numerical value, column 4 has a letter. Column
5 and 6 both have numerical values. First I want to check column 4 for a
letter, if it is a U, then do nothing, if it is anything else, then go to
column 3 and compare it to columns 5 and 6. If the value in column 3 exceeds
column5, turn cell color blue, if column 3 exceeds the value in column 6,
turn the cell red. (hard part - also turn the cell in column 4 the same
color). Column 5 and 6 could possibly be blank. Last item, can I bold
column 3 if column 4 is not U?
Reply
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
I Need a formula to evaluate a cell with + or - values Bob in Oklahoma Excel Worksheet Functions 6 October 31st 05 02:41 PM
Cell Change Color - Need Help alani New Users to Excel 3 June 29th 05 03:50 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Cell references change when entering new data [email protected] New Users to Excel 2 May 6th 05 07:48 PM
Look for change next blank cell in Range Nigel Bennett Excel Worksheet Functions 1 March 13th 05 09:45 PM


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