| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change colour of cells depending on entry in one cell
In one column (F), I have data like 0, 10, 30, 60, 90 and 100. I need to
change the background colour of another column (B) depending on what the entry is in column F. e.g. f2 = 0 or 100 then a2 = red, 30 = blue, 60 = orange, 90 = green, 10 = no change |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel spreadsheet change colour of cell back ground depending on d | Excel Discussion (Misc queries) | |||
| how do i change cell background colour depending on its content? | Excel Discussion (Misc queries) | |||
| function to count the amount of cells depending on part of the cell entry | Excel Worksheet Functions | |||
| Changing cell colour depending on another cells value... | Excel Discussion (Misc queries) | |||
| How can i change cell colour depending on month of date in cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
