Conditional formating

W

Walley

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formating 1
Transfer data between two tables 3
Adding cells until they are greater than a lookup cell and returning a value 1
Help with conditional formatting in Excel 2010 8
VLOOKUP over three spreadsheets 8
Changing row background from external program 0
Using Dates in Conditional Formatting 9
Conditional Format Won't Update Cell 8

Top