LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
HR Manager
 
Posts: n/a
Default Formatting Color into cells

I'm working on a payroll spreadsheet and I have created an IF statement into
a cell. The problem is that I need the IF statement to put in either "Over
Budget" or "Under Budget" in the cells. If it it "Under Budget" I need the
cell to be green with the text. If it is "Over Budget" I need the cell to
turn red. How do I do this?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying cells with conditional formatting Benfanfromlo Excel Discussion (Misc queries) 3 February 10th 05 06:12 PM
Determine cells that drive conditional formatting? Nicolle K. Excel Discussion (Misc queries) 2 January 7th 05 01:08 AM
Formatting cells in Excel for certain Values to appear certain Col Lucius Excel Worksheet Functions 2 December 24th 04 10:47 AM
background formatting across multiple cells Casper Excel Discussion (Misc queries) 0 November 26th 04 11:18 AM
Cells losing formatting BdgBill Excel Discussion (Misc queries) 1 November 26th 04 08:03 AM


All times are GMT +1. The time now is 08:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"