Need help in conditional formatting

E

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
 
U

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
 
E

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

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
 
Top