Highlighting Cells with IF - A Step-by-Step Guide

  • Thread starter Thread starter djeipa
  • Start date Start date
  • Tags Tags
    Cells
Click For Summary

Discussion Overview

The discussion revolves around how to use the IF function in spreadsheet applications to highlight cells based on certain conditions. Participants explore methods for changing cell colors and text colors automatically based on specified criteria.

Discussion Character

  • Homework-related, Technical explanation

Main Points Raised

  • One participant asks how to highlight a cell using an IF statement, suggesting a format like IF(A1>100,HIGHLIGHT,NotHIGHLIGHT).
  • Another participant clarifies that they are interested in changing the color of a cell automatically.
  • A suggestion is made to look into the format cell functions for potential solutions.
  • A later reply confirms that the suggested method works and raises a further question about changing the color of text within a cell using IF.

Areas of Agreement / Disagreement

Participants appear to agree on the need to use format cell functions, but the discussion remains unresolved regarding the specific implementation of changing text color with IF.

Contextual Notes

There are limitations in the discussion regarding the specific functions available in different spreadsheet applications and the exact syntax required for achieving the desired outcomes.

djeipa
Messages
47
Reaction score
0
Hello, can you tell me hjow to highlight a cell with IF ?
eg IF(A1>100,HIGHLIGHT,NotHIGHLIGHT) <<<<<< somethin like that ?

Thank you :smile:
 
Computer science news on Phys.org
Highlight,
I mean to change the color of a cell automaticily, thanks
 
Dr Transport said:
Look in the format cell functions...
Thank you doc, it works perfectly
I am thinking bout how to change even the color of my text in the cell, is there any way taht can do with IF? thanks guru
 

Similar threads

Excel automatically highlighting row and column
  • · Replies 4 ·
Replies
4
Views
3K
Why is the Highlighted Statement True?
  • · Replies 15 ·
Replies
15
Views
1K
Understanding DRAM Refresh Operations
  • · Replies 14 ·
Replies
14
Views
7K
Macro/close up photography equipment
  • · Replies 8 ·
Replies
8
Views
2K
Natural Selection Simulator like Conways' Game of Life
  • · Replies 8 ·
Replies
8
Views
3K
SSW of a translated cell (via TRCL)?
  • · Replies 1 ·
Replies
1
Views
2K
How to Factor Vapor Retarders into Relative Humidity & thus Mold Risk
  • · Replies 3 ·
Replies
3
Views
2K
Proving the results for the trace of a matrix
  • · Replies 4 ·
Replies
4
Views
2K
How do copper oxide solar cells work?
  • · Replies 2 ·
Replies
2
Views
2K
High School PV cell charge separation by an external electric field
  • · Replies 13 ·
Replies
13
Views
4K