nader assaleh
Member
Guys
if i have a value of 1110 as in cell F5 (value is 1110),how can i set conditional formation for the table C10:D28 that do the following
1- if exact value is available in the table the it underline value in that cell (cell C20) and it also underline the cell D20
2- if exact value is not there, then it underline the value that proceeds 1110 and the value the follow 1110 ( cell C20 and C21 and underline D20).
many thanks
if i have a value of 1110 as in cell F5 (value is 1110),how can i set conditional formation for the table C10:D28 that do the following
1- if exact value is available in the table the it underline value in that cell (cell C20) and it also underline the cell D20
2- if exact value is not there, then it underline the value that proceeds 1110 and the value the follow 1110 ( cell C20 and C21 and underline D20).
many thanks