ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   colors in excel formulas??? (https://www.excelbanter.com/excel-worksheet-functions/14649-colors-excel-formulas.html)

cari

colors in excel formulas???
 
is there a way to put colors in a formula...for example, if a4=0, the
background in a4 becomes yellow. ???

Jason Morin

You can use Conditional Formatting. In your case:

1. Select A4.
2. Go to Format Conditional Formatting
3. Choose "Cell Value Is", then choose "Equal to" and put
0 in the third box.
4. Click the Format radio button and format pattern as
yellow.

To see more examples, go to:

http://www.contextures.com/xlCondFormat01.html

HTH
Jason
Atlanta, GA

-----Original Message-----
is there a way to put colors in a formula...for example,

if a4=0, the
background in a4 becomes yellow. ???
.



All times are GMT +1. The time now is 04:58 PM.

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