IF-Condition coloring cell
Yaerox
I'd like to compare 2 cells (A1 and A2 - both formatted hh:mm) and color one cell, A3, depending on the result of the comparison of A1 and A2.
A1: Hours per day to work: 8
A2: Hours worked: 8
Pseudo Statement
IF (
A1 = A2,
"",
IF (
A1 > A2,
COLOR_CELL( A3 ),
IF (
A1 < A2,
COLOR_CELL( A3 )
)
)
)
I researched but I only found that you can use conditional formatting. This doesn't seem to help me ... is this possible?
Ron Rosenfeld
You wrote that you could not use conditional formatting because I can't multiple events on one cell using conditional formatting. Note in the screenshot that we have multiple rules applying to cell A3, which is colored according to those rules:
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Spring XD, Reactor Streams: configuration without XML?
- Next: How can I animate from left to right the searchbar in a searchdisplaycontroller?
Related
Related Related
- 1
Coloring Text in JTable Cell
- 2
Datagridview coloring cell
- 3
Coloring if() condition in exel
- 4
Excel Cell Coloring using xlsx
- 5
DataGridView cell coloring throws error
- 6
Excel VBA - Extremely slow cell coloring
- 7
IE not coloring :before as table-cell, why?
- 8
VBA Coloring Bar Charts Based on Cell Color
- 9
Coloring partial text within cell in Excel
- 10
Fine Grained Cell Coloring with Excel and .NET
- 11
JavaFX : Coloring TableView row and formatting the cell text
- 12
coloring primefaces table cells depending on condition
- 13
coloring primefaces table cells depending on condition
- 14
coloring text in a time when condition is fulfilled
- 15
IF (Condition) and (another condition) increment cell
- 16
If Cell empty then condition
- 17
Highlighting cell using if condition
- 18
How to use python to save dict as a table in PDF with cell coloring?
- 19
Coloring separate rows based on matching of data in key cell
- 20
Kendo UI Grid cell coloring in MVC4
- 21
Coloring a single cell in a JTable when representing Color objects
- 22
Microsoft Excel cell coloring using values of other cells
- 23
C# WPF Datagrid coloring a cell with code behind
- 24
Column Chart with condition-based coloring in R and highcharts
- 25
VBA Excel - Coloring eacht cell in a row that contains a value based on the value of another cell
- 26
Add value to cell if condition is meet
- 27
Custom TableView Cell ,check condition
- 28
Add formula containing condition to cell
- 29
EXCEL: change the color of a cell at a condition
Comments