| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
complex conditional format
I have a cell value based on a calculation,which gives me any one of 7
values.The cell values a-"DEAD","DEAD & DEAD","DEAD & LIVE","LIVE & DEAD","LIVE","LIVE & LIVE",BLANK CELL. I would like to apply conditional format of that cell-"DEAD" word to red bold font 11 with a color shade,and "LIVE" word to blue bold font11 with the same color shade.Since I can apply only three conditions and a cell value can't accept two formats at a time,I am unable to do the task.Can any one suggest me how to do this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format numbers | Excel Worksheet Functions | |||
| Cell Format Changes When Data Is Entered - Not Conditional Formatt | Excel Worksheet Functions | |||
| Conditional format of minimum number | Excel Worksheet Functions | |||
| Conditional Format Question | Excel Worksheet Functions | |||
| Conditional Format | New Users to Excel | |||
Threaded Mode
