var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: excel query
i am trying to replace a cells contents based upon the contents of another cel so if d1='absent' i want cell a1 to be "A" and fill red any ideas please?
In cell A1 enter:
Now use conditional formatting in cell A1.
"Format cells that contains"
"Cell value equal to A"
thankyou for the response i also already have a =index match lookup in this cell can i add the formulae that you have given to me to this.
this is the command that i already have where it looks for a persons required hours but if they are absent i want to overide it and place an "A"
and the cell go red
hope that you can help ?