| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Changing cell formatting with IF function
I am trying to set up a code to change the cell color and font color depending on the entry in a particular cell.
Example: If C2 is "John", then D2, E2, F2, G2 cell colors change to red with white, bold lettering. If C2 is anything but "John", the D2, E2, F2, G2 cell colors stay normal, as does the font. Can anyone help me with this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
| How do I obtain the address of a cell using the vlookup function? | Excel Worksheet Functions | |||
| clock | Excel Worksheet Functions | |||
| Function to determine if any cell in a range is contained in a given cell | Excel Worksheet Functions | |||
| Function making cell really "empty" | Excel Worksheet Functions | |||
Threaded Mode
