EXCEL FUNCTIONS

[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

 

[Ken Wright]

Format / Conditional Formatting, change 'cell value is' to 'formula is'

 

[JE McGimpsey]

Worksheet functions can't change cell colors. However, look up
Conditional Formatting in XL Help.

 

[Norman Harker]

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.