Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional fill colour
hi - hope someone can help!
i've got 5 cells in a row - i want to be able to input a number ( 1 to 5 ) into the 6th cell and automatically colour in the respective cell. for example if i input number 3 - then i want cell number 3 to change colour and all the rest to remain unfilled. i've tried conditional formatting but that will only change the colour of the input cell. i've tried the if function too but there doesn't seem to be a option for changing cell colour. any ideas? cheers AK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Conditional formatting: Colour coding | Excel Discussion (Misc queries) | |||
Conditional color fill whole line... | Excel Worksheet Functions | |||
How to fill colour in Excel, it appers No fill in my computer? | Excel Discussion (Misc queries) | |||
Fill colour red | Excel Discussion (Misc queries) |