Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
change excel cell colour using If
Name: Aralius Date: February 11, 2005 at 10:34:20 Pacific OS: windows xp CPU/Ram: 1.3
Comment:
I am trying to change the colour of a cell using the "If Function" i.e. If value of the cell is greater than 20, change colour of cell to green, else colour to be red.
Name: dtech10 Date: February 11, 2005 at 16:24:14 Pacific
Reply:
Hi Try using Format>Conditional Formating.
0
Response Number 2
Name: Aralius Date: February 14, 2005 at 10:44:52 Pacific
Reply:
Thanks for the reply but i didn't really understand it. Could you please give me an example of the function that would relate to my earlier question.
Thanks
0
Response Number 3
Name: dtech10 Date: February 16, 2005 at 04:33:53 Pacific
Reply:
Hi Select all the cells you want coloured then select Format>Cells>Pattern Tab and select your red color, to color all the cells. Select them all again and select Format>Conditional Format and select or enter these values.
| Cell Format is | between | 20 | 1000 | then select your Format>Patterns from the same dialog and choose you green color. Change the 1000 to your own upper limit.
Summary: I would like to have a batch file that looks for a file on a network drive, if it doesn't find it, it waits for 10 seconds or so, & looks for it again. I've seen batch files like this that use IF EXIS...
Summary: Hey guys I m back with another challenge... I want to use if else statement using batch file. Here is my condition for If statement is that I Want to get count from one of our Oracle data base and if...
0 
