| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill cell colour based on input in another cell
I have a sheet with a number of links to another worksheet. What i now want
to add is automatic colour change in cells dependant on input from another formula eg:- If cell B3 formula answer says E i want all cells below in the same column to turn a different for example blue. There will be four possible options :- E L M or O, and the fields needing filling will be from B6 - B31 to P6 - P31 Is there a macro as i have used contitional formating for another field? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to input pictures automatically based on cell input? | Excel Worksheet Functions | |||
| fill cell with colour if preceding cell is a negative value | Excel Discussion (Misc queries) | |||
| conditional colour fill a row - based on cell value =100% | Excel Worksheet Functions | |||
| How to make a cell copy the fill colour of another cell | Excel Worksheet Functions | |||
| Fill colour a cell from the linked cell | Excel Discussion (Misc queries) | |||
![Dan Wood[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
