D
DFDGirl
Hi there,
I have a monthly report that I am creating which calculates the amount
spent in relation to what was budgeted for. Thus I have a calculation
that is a percent.
What I would like to do is set my conditional formatting to acknowledge
the percents greater than 25% and highlight in yellow.
What I am getting are .02 or .53's highlighted in yellow but really no
rhyme or reason and definitely not a .25.
Any suggestions?
I have a monthly report that I am creating which calculates the amount
spent in relation to what was budgeted for. Thus I have a calculation
that is a percent.
What I would like to do is set my conditional formatting to acknowledge
the percents greater than 25% and highlight in yellow.
What I am getting are .02 or .53's highlighted in yellow but really no
rhyme or reason and definitely not a .25.
Any suggestions?