Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Cell Change Color - Need Help | New Users to Excel | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Cell references change when entering new data | New Users to Excel | |||
Look for change next blank cell in Range | Excel Worksheet Functions |