ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   if statement format cell (https://www.excelbanter.com/excel-worksheet-functions/87595-if-statement-format-cell.html)

Jane

if statement format cell
 
Can I use an IF statement (or anything else) so that the answer to a question
in one cell dtermines the colout of ANOTHER cell?

Stefi

if statement format cell
 
Yes! See Conditional formatting in Help (formula option) or give more details
on what do you want to do!

Regards,
Stefi


€˛Jane€¯ ezt Ć*rta:

Can I use an IF statement (or anything else) so that the answer to a question
in one cell dtermines the colout of ANOTHER cell?


Ardus Petus

if statement format cell
 
You must use conditional formatting on the "OTHER" cell, with a formula
which refers to your original cell.

HTH
--
AP

"Jane" a écrit dans le message de news:
...
Can I use an IF statement (or anything else) so that the answer to a
question
in one cell dtermines the colout of ANOTHER cell?





All times are GMT +1. The time now is 01:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com