I was writing a quick gantt chart spreadsheet using conditional format which has been completed.
(you probably know how it was done... just by simple T/F value and changing font and cell colour by conditional format in excel)
i just want to add one additional feature, best without VBA (considering potential user)
to change the cell colour of the gantt chart by colour code stored in another cell.
for example, in row 10, a cell value at AA10 of "FF0000" could change the colour of highlighted cells (using conditional format) into red
while a cell value in AA12 of "00FF00" would change the bar colour to green... etc.
Is it possible to do it without VBA?
P.S. was there any good gantt chart spreadsheet for use or reference?
many thanks.
LAM
(you probably know how it was done... just by simple T/F value and changing font and cell colour by conditional format in excel)
i just want to add one additional feature, best without VBA (considering potential user)
to change the cell colour of the gantt chart by colour code stored in another cell.
for example, in row 10, a cell value at AA10 of "FF0000" could change the colour of highlighted cells (using conditional format) into red
while a cell value in AA12 of "00FF00" would change the bar colour to green... etc.
Is it possible to do it without VBA?
P.S. was there any good gantt chart spreadsheet for use or reference?
many thanks.
LAM
