Need help in conditional formatting

[etks]

Appreciate if someone could help.
Column A and B comprises some percentages numbers. I wish to configure column B such that if the values in column B is greater than A, change the text to blue. if the value in column B is smaller than A, change the text to red. As i have plenty of rows, it is tedious to do it cell by cell for 300 plus rows. Thanks

[ufo_pilot]

Conditional format your first cell in column B by selecting FORMAT >
CONDITIONAL FORMAT
Take the "$"-sign out of the row number ( $A$1 should be $A1, or just A1)
select a format, then either copy and paste special > formats
or use your paintbrush icon (doubleclick to use on multiple cells) and
scroll over all the cells that need this format


"etks" wrote:

>
> Appreciate if someone could help.
> Column A and B comprises some percentages numbers. I wish to configure
> column B such that if the values in column B is greater than A, change
> the text to blue. if the value in column B is smaller than A, change
> the text to red. As i have plenty of rows, it is tedious to do it cell
> by cell for 300 plus rows. Thanks
>
>
> --
> etks
> ------------------------------------------------------------------------
> etks's Profile: http://www.excelforum.com/member.php...fo&userid=6462
> View this thread: http://www.excelforum.com/showthread...hreadid=500586
>
>

[etks]

thanks, ufo_pilot. maybe i wasn't clear. refer below. thanks
1% 2% the 2% should be in blue because it is greater than cell A2
2% -1% the -1% should be in red because it is less than cell A3
3% -2% the -2% should be in red beause it is less than cell A4
8% 5% the 5% should be in blue because it is greater than cell A5
please take that the numbers in the rows of column A and B will change constantly, which is why I need
to use conditioning formatting otherwise I have to colour it manually

[B. R.Ramachandran]

Hi,

Let's assume that the data start at Row 2 (i.e., the first pair of numbers
are in A2 and B2).
Format the entire column B for Blue font. Now select the entire range in
column B (e.g., B2:B301) --> "Format" --> "Conditional Formatting" -->
"Formula Is" =$B2<$A2, format the font to be Red --> "OK" (Note that there
are no $ symbols before the '2's in the formula).

If you want the Conditional Formatting to be able to accommodate more rows
as additional data are added over time, select an extended range (e.g.,
$B2:$B501) instead of the actual data range ($B2:$B301) before you do the
font-formatting vis-a-vis CF.

Regards,
B. R. Ramachandran


"etks" wrote:

>
> Appreciate if someone could help.
> Column A and B comprises some percentages numbers. I wish to configure
> column B such that if the values in column B is greater than A, change
> the text to blue. if the value in column B is smaller than A, change
> the text to red. As i have plenty of rows, it is tedious to do it cell
> by cell for 300 plus rows. Thanks
>
>
> --
> etks
> ------------------------------------------------------------------------
> etks's Profile: http://www.excelforum.com/member.php...fo&userid=6462
> View this thread: http://www.excelforum.com/showthread...hreadid=500586
>
>