| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use cond format formula to set cell text and color?
Using MS Excel 2003:
As and example, I entered into Conditional Format for cell B1: "Formula is", IF(A1="","Test",""). For true condition, the format is set to fill Yellow and font color red. I'm expecting cell B1 to display, "Test" in red text with yellow background when A1 is blank, but it does not work. No errors are displayed. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change color of a cell if another cell has text in it | Excel Discussion (Misc queries) | |||
| text color change in cell reference | Excel Discussion (Misc queries) | |||
| Cell text color change | Excel Discussion (Misc queries) | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
