EXCEL FUNCTIONS

  • Thread starter Thread starter RHEBERT
  • Start date Start date
R

RHEBERT

Can cells be made to change background color when using a
function like IF or AND (ie - if a statement is true, the
cell would change color).

Thanks
 
Worksheet functions can't change cell colors. However, look up
Conditional Formatting in XL Help.
 
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.
 
Back
Top