ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Conditional formating (https://www.excelbanter.com/excel-worksheet-functions/240734-conditional-formating.html)

Walley

Conditional formating
 
Hi!
I use Excel 2007, I need some help:
1-If the value of cell B3 is greater, less or equal to 0, I want to apply a
conditional formatting (changing color of cell, color of border) to C3.
2-If the value of cell B3 is greater, less or equal to 0, I want to apply a
conditional formatting to display words €˜greater, €˜less or €˜equal to D3.
3-If the value of cell B3 is greater, less or equal to 0, I want to apply a
conditional formatting to set only icons to E3, I mean the three icons which
represent €˜greater, €˜less or €˜equal. I want to display only icons without
values in cell E3.
Thanks for your help.


Herbert Seidenberg

Conditional formating
 
Excel 2007
Conditional Formatting, Icons
http://www.mediafire.com/file/nt1nglry1nw/08_26_09.xlsx


All times are GMT +1. The time now is 01:11 PM.

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