• AVERAGE
  • AVERAGEIF
  • CELL REFERENCE
  • COUNT
  • COUNTA
  • COUNTIF
  • SUM
  • SUMIF
  • VLOOKUP
Get FREE step-by-step guidance on your question from our Excel Experts.
Quick Excel Help
  • AVERAGE
  • AVERAGEIF
  • CELL REFERENCE
  • COUNT
  • COUNTA
  • COUNTIF
  • SUM
  • SUMIF
  • VLOOKUP

Are you stuck on Excel or Google Sheets?

Check out some problems solved by our top Experts or click here to post your own problem for free!

  • All solutions
  • CONDITIONAL FORMATTING
  • Based On
I need a conditional formatting formula to change the color and text of a cell in row 2 based on a numerical value in row 1.
Solved by E. L. in 29 mins
Conditional formatting - I'm trying to change the format of a cell based on the value in another cell. I have a table with 100+ lines; when column E reads "complete," I want column C to go back to plain format
Solved by Z. Y. in 7 mins
Formula help: =COUNTBLANK(offset(Inglewood!C$2,,MATCH(D3,Inglewood!$C$1:$N$1,0)-1,counta(Inglewood!$A:$A)-1)) This is helping me have conditional formatting based on empty cells from another tab. I want to change the range of data that is being seen. (i.e. instead of C2:C47 I want it to be C11:C47)
Solved by V. U. in 31 mins
I need help with conditional formatting. I would like to highlight cells based on a "yes/no" value rather than numeric digits.
Solved by V. J. in 16 mins

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.

To find out more, see here: Cookie Policy
  • Home
  • About
  • Excel Tutorial
  • Excelchat
  • Team
  • Excel Problems
  • NL to SQL
  • Experts
  •  
  • Platform
  • Contact
  •  
  • Labeling
  • Press
© 2019 Got It, Inc. All rights reserved.
Got it! Your question will be answered by an Excelchat Expert. Hang tight for 30 secs while we redirect you.

Save time by asking instead! Most questions solved and answered in 10 minutes.

Post your problem and you’ll get expert help in seconds.
Your message must be at least 40 characters
Free trial ends in 00 days 12 hours