#conditional-formatting

[infobotbiz-blog]

Fix: Date Formatting in Google Spreadsheet #computers #answer #dev

Fix: Date Formatting in Google Spreadsheet #computers #answer #dev

Date Formatting in Google Spreadsheet

I use a spreadsheet in my medical office for referrals. It includes places to fill in these three areas: date faxed, date of the appointment, date the appointment office notes were received. The problem is that sometimes people don’t go to the appointments. I want the ‘date of the appointment’ box to highlight in yellow if it has been 1 monthsince the ‘date…

View On WordPress

[goodanswerbiz]

How to: Conditional formatting color gradient #answer #dev #computers

How to: Conditional formatting color gradient #answer #dev #computers

Conditional formatting color gradient

A few friends and myself have created a Google Spreadsheet where we are keeping track of virtual item sales. One column has costs, one column has income one has profit, and a fourth has a running total of funds.

I’d like to be able to make the column with profit to be very green for very large numbers, so they are visible while glancing over the document.

I…

View On WordPress

[goodanswerbiz]

How to: Conditional formatting using other cells in Google Docs #it #solution #answer

How to: Conditional formatting using other cells in Google Docs #it #solution #answer

Conditional formatting using other cells in Google Docs

I could use some help with conditional formatting.

I would like to format the first 6 cells in a row in a Google Docs file based on the following condition: If column A is not empty and column C is, change the background of the cells in A-F to red.

How can I do this?

Answer [by thats_how_i_feel]: Conditional formatting using other cells in…

View On WordPress

[infobotbiz-blog]

How-to: Is it possible to add conditional formatting when number changes? #computers #it #dev

How-to: Is it possible to add conditional formatting when number changes? #computers #it #dev

Is it possible to add conditional formatting when number changes?

This is probably not possible but…

I’m looking to update cells in a Google spreadsheet using the conditional formatting tool.(Changes to SERPs rankings)

So when the number in a cell is changed, it recognises if the number was greater or lesser than the current number and then changes the cell colour to red for lesser and green for…

View On WordPress

[infobotbiz-blog]

Answer: How can I set conditional formatting on particular cells that depend on another cell's value in Google Spreadsheets? #programming #answer #dev

Answer: How can I set conditional formatting on particular cells that depend on another cell's value in Google Spreadsheets? #programming #answer #dev

How can I set conditional formatting on particular cells that depend on another cell’s value in Google Spreadsheets?

I would like to colour the background of a row in Google Spreadsheets:

For example:

If cell Dx = title ‘To do’ or ‘title ‘Done’ then cells Fx to Nx are filled colour black.

If cell Dx = title ‘closed’ the font colour of cell Ax to Nx turns green.

I can do this in Excel quite…

View On WordPress

[goodanswerbiz]

Fix: Advanced date logic in Google Spreadsheets #dev #solution #fix

Fix: Advanced date logic in Google Spreadsheets #dev #solution #fix

Advanced date logic in Google Spreadsheets

I have the folowing situation:

Today is 4/9/12. I have a cell with a date in the sheet that is 4/13/12. This cell should turn red since it is within 7 days from the current date.

What is a way to use conditional formatting to get Google Spreadsheets to highlight cells that are up to 7 days away from current date?

How can I get the spreadsheet to sort…

View On WordPress

[infobotbiz-blog]

How-to: Google Spreadsheet - changing row colour if value set? #fix #development #solution

How-to: Google Spreadsheet – changing row colour if value set? #fix #development #solution

Google Spreadsheet – changing row colour if value set?

I’m trying to use the following script to change the row colour if a value in column N is set:

function onEdit() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheetByName('Sheet1'); var rows = sheet.getRange('n3:n700'); var numRows = rows.getNumRows(); var values = rows.getValues(); for (var i = 0; i <= numRows - 1;…

View On WordPress

[infobotbiz-blog]

Solution: Google SpreadSheet conditional formatting based on number of characters #answer #fix #solution

Solution: Google SpreadSheet conditional formatting based on number of characters #answer #fix #solution

Google SpreadSheet conditional formatting based on number of characters

In Google Spreadsheet, is there a way to conditionally format a cell if it has more than 30 characters?

Answer [by Jacob Jan Tuinstra]: Google SpreadSheet conditional formatting based on number of characters

Not on the cell itself, without the usage of Google Apps Script. Adding a helper column will allow you get realy close:

View On WordPress