| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Font Colour and Background If Q
I wish to change the Font & Background colour if a cell = a certain
value. I can't use Conditional Formatting as I have 28 variables that the cell value could be. I have seen an add-in on this Newgroup, but I'm trying to design a workbook for 5 users and I dont wish to install this on each Laptop. My Workbook will have a Data Validation Drop down list that the user will select a certain location from, if the location Selected = "London" I wish for the Background to change to Red and Font to White etc etc How would I do this through VB Thanks for any help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing a cell including background colour... | Excel Worksheet Functions | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
| change background colour | Excel Discussion (Misc queries) | |||
| how do I change general background colour | Excel Discussion (Misc queries) | |||
| Conditional format if cell=0 then font colour same as background . | Excel Discussion (Misc queries) | |||
Threaded Mode
