27 дек. 2016 г. · The documentation reads: The value 1 if the cell is formatted in color for negative values; otherwise returns 0 (zero).

19 дек. 2022 г. · I'm a beginner and trying to create a formula that modifies the contents of Cells of Column J based on the color of the cells in correspondent rows.

2 февр. 2015 г. · Select the appropriate column and go to Home -> Conditional formatting -> Highlight Cells Rules. Afterwards you can define the criteria, and which color the ...

25 янв. 2023 г. · In Excel, the Conditional Formatting can do this. Select the range of cells, and click Home > Conditional Formatting > New Rule.

24 июн. 2014 г. · Try this: Add a Name(any valid name) in Excel's Name Manager under Formula tab in the Ribbon. Then assign a formula using GET.CELL function.

23 июн. 2020 г. · I want to set cell A1 color to red if cell G1 is green and the same time I want to set cell A1 color to yellow if cell F1 is not empty.

28 нояб. 2019 г. · I want to put a function into a cell, =Colour(R, G, B), where R, G, & B are selected reference cells (eg =Colour(A1, A2, A3) ) representing Red/Green/Blue

3 окт. 2014 г. · Create another rule and enter the formula =IF(B2="X",IF(B3="W", TRUE, FALSE),FALSE) and choose to fill red when this is true. More details - ...

16 окт. 2015 г. · I'm trying to write a function in Excel that will set the background color of the active cell according to the values stored in other three cells.

15 нояб. 2013 г. · On the Excel Ribbon, go to "Formulas" and click on "Name Manager". Select "New" and then enter "CellColor" as the "Name".