Related:
- Excel insert value based on another cell
- Excel insert rows based on cell value - Forum - Excel
- Auto insert 'x' rows depending on value 'y' - Forum - Excel
- Code for macro that conditionally inserts rows ✓ - Forum - Excel
- Insert rows on change of value in Excel table ✓ - Forum - Excel
- Excel insert picture based on cell value - Forum - Excel
2 replies
Mazzaropi
- Posts
- 1950
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- January 9, 2022
doublewitt, Good afternoon.
"...CONDITIONAL FORMATTING for cell A2:..."
As the name says, Conditional Formatting only changes the FORMAT of a cell, not the content.
It works the aesthetic aspect of the cell.
For the formula:
A2 --> =IF(C3>500,"alert","")
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
"...CONDITIONAL FORMATTING for cell A2:..."
As the name says, Conditional Formatting only changes the FORMAT of a cell, not the content.
It works the aesthetic aspect of the cell.
For the formula:
A2 --> =IF(C3>500,"alert","")
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
doublewitt
- Posts
- 14
- Registration date
- Sunday April 27, 2014
- Status
- Member
- Last seen
- September 29, 2014
OK - thanks, works fine
