View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default complex conditional format



--

HTH

RP
(remove nothere from the email address if mailing direct)


"TUNGANA KURMA RAJU" wrote in
message ...
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.