python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - conditional-formatting

Conditional formatting in Google Sheets is recognizing some cell values that equal 0, not others

I have two columns in my sheet where I would to use conditional formatting. I'd like the cells to be turned green when the value = 0 be red when the value != 0. Here's how I have the conditional for...
test-img

maefleurs

google-sheets

conditional-formatting

Votes: 0

Answers: 1

Latest Answer

This is due to the precision of the calculation, especially if you work with days and hours in W, AE and AF. So try to round the results. ROUND() for instance =round(___your formula____,6)
test-img

Mike Steelson

Excel workbook causes Excel to crash when opening another workbook - 4 contributing factors identified but actual cause unknown

I've encountered an unusual bug in Excel that results in the whole programme crashing without warning, any form of error notification (including upon startup), or any acknowledgement that it crashed. ...
test-img

Steve

excel

vba

function

crash

conditional-formatting

Votes: 0

Answers: 1

Latest Answer

Scenario Detected Giving the office 32 bit version and one add-in that you have listed I can get some pointers on at least one of the factors: I have noticed that having Oracle Smart View enabled caus...
test-img

Sgdva

Excel Conditional Formatting formula based on the last date of one column for certain criteria in another column

I have a table with Column A being the Criteria and Column B being the Date. I need help with a conditional formatting formula to highlight the latest date for a all the unique criteria. See screensho...
test-img

Scotty

excel

excel-formula

dax

conditional-formatting

Votes: 0

Answers: 1

Latest Answer

You can make a conditional formatting formula with: =MAX( ($A$2:$A$10=A2) * $B$2:$B$10 ) = B2 where your data are in A2:B10.
test-img

mark fitzpatrick

Google Sheets: Cell color hex value to be fetched from another cell's value

I have a Google Sheets file that contains 2 sheets: L1: A listing of my expenses (screen shot) As you can see, there are two columns named Tag #1 and Tag #2. These are linked to a list of tags I've c...
test-img

TheLebDev

google-sheets

hex

conditional-formatting

drive

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs