Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If value in column is yes; entire line turns red
I am setting up a new feature in my client database. The last column will be (Any outstanding debts) if the value in this column is YES (or 1 if it needs to be a number) I would like the whole line (from contact details to handphone number) to be written in red. This will allow for a quick scan of my bad clients in terms of payment. Any help here on how to do this is much appreciated =) -- Geert_Pick ------------------------------------------------------------------------ Geert_Pick's Profile: http://www.excelforum.com/member.php...o&userid=23222 View this thread: http://www.excelforum.com/showthread...hreadid=518574 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If value in column is yes; entire line turns red
Hi Geert,
Say column J is the last column, the column with the YES for outstanding debts, and your data base rows are from row 2 to row 100. 1. Select your database cells 2. Go FormatConditional formatting... 3. If the box below Condition 1 shows "Cell Value Is" click on the arrow and select "Formula Is" 4. In the box to the right type =$J2:$J100 = "YES" 5. Click on the Format... button 6. Change the font color to red then click OK on the Format Cells dialog 7. Click on the OK button on the Conditional Formatting dialog. Ken Johnson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If value in column is yes; entire line turns red
Hi,
Look at conditional formatting (Select all of the rows you want & then 'Format', 'Conditional Formatting'). Choose 'Formula Is', your formula will need to be something like; =IF(B$6="Yes",TRUE,FALSE) Set the background on the 'Patterns' tab that appears when you hit 'Format ....' Regards, Chris. -- Chris Marlow MCSD.NET, Microsoft Office XP Master "Geert_Pick" wrote: I am setting up a new feature in my client database. The last column will be (Any outstanding debts) if the value in this column is YES (or 1 if it needs to be a number) I would like the whole line (from contact details to handphone number) to be written in red. This will allow for a quick scan of my bad clients in terms of payment. Any help here on how to do this is much appreciated =) -- Geert_Pick ------------------------------------------------------------------------ Geert_Pick's Profile: http://www.excelforum.com/member.php...o&userid=23222 View this thread: http://www.excelforum.com/showthread...hreadid=518574 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Making Hyperlinks Active In Entire Column | New Users to Excel | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
a fomula for an entire column | Excel Discussion (Misc queries) | |||
how do I change a line series to a column series in excel? | Charts and Charting in Excel |