| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet code if-color-statement
Hi, I'm trying to do a code without succeding, in Worksheet that says i color =red or black: Anyone? IF B3:D3=red, copy formula from BG4:BL33, paste in E4:J33 IF K3:M3=red, copy formula from BG4:BL33, paste in N4:S33 IF T3:V3=red, copy formula from BG4:BL33, paste in W4:AB33 IF AC3:AE3=red, copy formula from BG4:BL33, paste in AF4:AK33 IF AL3:AN3=red, copy formula from BG4:BL33, paste in AO4:AT33 IF AU3:AW3=red, copy formula from BG4:BL33, paste in AX4:BC33 IF B3:D3=black, copy formula from BU4:BZ33, paste in E4:J33 IF K3:M3=black, copy formula from BU4:BZ33, paste in N4:S33 IF T3:V3=black, copy formula from BU4:BZ33, paste in W4:AB33 IF AC3:AE3=black, copy formula from BU4:BZ33, paste in AF4:AK33 IF AL3:AN3=black, copy formula from BU4:BZ33, paste in AO4:AT33 IF AU3:AW3=black, copy formula from BU4:BZ33, paste in AX4:BC33 Thanks in advance //Thoma -- Jonsso ----------------------------------------------------------------------- Jonsson's Profile: http://www.excelforum.com/member.php...nfo&userid=547 View this thread: http://www.excelforum.com/showthread.php?threadid=26453 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I color code worksheet tabs please? | Excel Discussion (Misc queries) | |||
| How to color automatically color code sums in cells | Charts and Charting in Excel | |||
| Should be able to color code or highlight Excel worksheet tabs. | Excel Worksheet Functions | |||
| How do I color code a worksheet based on text | Excel Discussion (Misc queries) | |||
| Change Color on an IF statement | Excel Worksheet Functions | |||
![Jonsson[_43_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
