You can do this with conditional formatting - no code needed

Format=Conditional formatting

--
Regards,
Tom Ogilvy

Mike Fogleman wrote in message
...
Hi, I have two columns of data B & K with same number of rows. Column K
values are the result of a cell formula. I want to change the text color
of
B5 to red if it is less than K5. I have a variable named RowCount
available
with the number of rows that are in the columns if that can be of any use.

TIA Mike