hi
following are the requirement
if d = pending with UIDAI(DQC) & E= ""(blank) column G will reflect pending with customer.
if d= other option & E=blank column G will reflect pending wth team.
if E= non blank column G will reflect closed
my column F function is working , were if criteria is...
hi,
Iam looking for formula to do conditional formatting with cumulative frequency.
Ex- 10-29 (yellow color)
30- 49 (Orange color)
50 & above (Red color)
Excel sheet is attached for your reference( conditional formating required for colum d,e,f,g ,i,j,k,l)
Pls guide
hi,
need the conditional formatting , where if two selected rows are not have same text or numerical will highlight the 1st column.
EX if A<>B, highlight A, RED.
in attachment the requirement is,
C<>G, highlight C, RED.
D<>I, highlight D, Green.
hi, need a help on setting if criteria on specific date.
While for calculation of TAT days before a specific date I need to set a another column against which their desired deadlines are set so that i can calculate their networkdays by subtracting it
EX- if a item was delivered in a location...
hi can any one help me on this through conditional formatting, new rule
if i write=ROW(A1)=selRow
=COLUMN(A1)=selCol
it converts into
=COLUMN(A1)=selCol
=ROW(XEV1)=selrow
& didn't get any result....
Pls suggest why iam getting error
Hi,
Unable to do it, with multiple criteria range.
1) countifs require for sales(column C, against column A, mgr)
Required to find out count of sales against mgr, but store location should be required to taken in critera to find the count as 2 mgrs are taking care of same location