SELECT name FROM bedroom
WHERE floorcolor = 'YELLOW'
OR ceilingcolor = 'YELLOW'
OR wallcolor = 'YELLOW'

Using OR increases the chances for careless mistakes instead
CONCAT could be used to make the query more efficient.
To avoid problems make sure to add in separators and if a value cna be null
make sure to use it is wrapped in COALESCE OR NVL for example:
COALESCE(floorcolor,).

SELECT name FROM bedroom
WHERE CONCAT (':',floorcolor,':',ceilingcolor,':',wallcolor,':')LIKE'%:YELLOW:%'