Hi Rhebert!
Let's say you have a function in B1
=IF(A1>0,"Credit","Debit")
Select B1
Format > Conditional Formatting
Formula is
=A1>0
Format
Pattern Tab
Select Blue
OK
OK
Just match the condition in your IF function with the condition used
for conditional formatting. If you want a format for the false return,
apply a second conditional formatting.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.